• Update excel charts auto from as400 data

    I have a user request to create charts in excel using data held on the as400. I can do this in seperate steps but the user wants it as automatic as possible. At the moment : I run a query on the as400 to create data file I transfer using client access I open in excel & then copy data to graph...

    Gerrib150 pointsBadges:
  • Critical Path

    I created a project plan and everything looks normal but when I want to view for a critical path (using Gant Wizard Chart), I don't see any critical paths. I am wondering what went wrong

    MSProject5 pointsBadges:
  • Microsoft Excel Graphing

    I need a line that is able to move. I want to grab it with my cursor and move it up and down on my bar graph. The bar graph is showing the zero to the max percentage of the percentage of income brackets for each year from 1913 to 2013. So there are 100 vertical columns (bars). The series of the...

    ITKE1,152,300 pointsBadges:
  • Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph?

    Excel 2007 - How do I ignore zero's and #DIV/0! for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% #DIV/0! 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% On the graph all u will see is the plots from week 1 & 2....

    Jreifenstein001185 pointsBadges:
  • Excel macro – create a chart

    I created a macro that reforms my data and creates a chart. Teh macro also includes selecting a chart layout that has an x and y axis field that I want to enter in some text. My macro works all the way except it does not record the content I put into the X and Y axis.   Why is that? and how can i...

    jkeri360 pointsBadges:
  • excel 2007 chart automation

    hi, I have a code that copy charts from one sheet to another sheet and plot graphs. But when I run multiple instances of excel simultaneously sometimes it copy all graphs and sometimes 2 ,4 or 6 charts. This application is working fine with EXCEL 2003 but with EXCEL 2007 giving above problem....

    Ps777self5 pointsBadges:
  • Microsoft Excel 2007 charts


    Jollybhupi5 pointsBadges:
  • Excel 2007 charts

    I have a macro that runs when a cell is updated by a PLC. When this cell changes its value I insert a cell into a column and copy data from another cell and paste it into that new inserted cell. My problem is that my chart that is associated with the data where the cell is inserted dissapears. I...

    JimGlover5 pointsBadges:
  • excel 2007

    I am trying to use non-adjacent ranges to setup a clustered column with 3D visual effect option by pressing the ctrl key and selecting my ranges and every time I get the box saying one can't use the chart with information selected, what am I doing wrong?

    Lisa1005 pointsBadges:
  • Excel 2000 Chart Won’t Automatically Update

    My Excel 2000 chart won't automatically update when I change the data in one/both of the columns in the attached spreadsheet. I have checked the automatic button under Tools/Option/Calculate, but it still does not work. The only way I can get it to work is if I go into the chart and change one of...

    Bacham5235 pointsBadges:
  • Data Label Help

    Hi I have made a stacked column graph comparing three types of presenters by percentage. I am trying to make a data label appear at the top of each three stacked bars that shows the total percentage for all three. I know I can do this by way of a text box but I would like the label to update...

    Hmarshall055 pointsBadges:
  • Excel graph gaps

    I would like to create an "x,y" type plot ("scatter graph" in Excel terms) in which the "x" array is continuous, but some of the "y" values are invalid because the formula has a limited valid range. I can use an IF to substitute "" or "nil" "invalid" or something for the invalid "y" values....

    TomGlass20 pointsBadges:
  • automatic publish of charts to web

    On worksheet (5) I have graphs based on the 4 previous sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the republishing to be automatic. The graphs are updated once the data is changed but I want the user to use the intranet rather than the spreadsheet.

    Gerrib150 pointsBadges:
  • Charts from internal references of external data

    I can access and process the external data from another worksheet just fine (I'm grabbing data from one excel spreadsheet to plot on another), but I need to process this data before plotting (I need to normalize the data to the max value in that column and the number of rows in each column...

    Nanopit5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.