Charting the Sum of Two, or More, Series of Data I know there must be a relatively simple solution to my challenge, short of creating a new series od data which is the sum of desired series. Let's say that I have the following 02/13/2010 02/20/2010 02/27/2010 ... 0-30 \$7,072,987 \$5,990,448 \$8,978,002 31-60 177,472 160,460 142,547 61-90 ... 22 Apr 2010 12:26 Sorting PivotChart Hi, In excel 2007 I want to sort data in the chart I made from pivot. I want them to be sort in descending order. The reason is, I need bar Pivotchart diagram to use as Pareto chart. I'm also using this new function in excel 2007 , "drill-down" or "drop-down" to multiple levels/layers in PivotChart. I want al... 20 Apr 2010 16:32 how can I plot a curve with variable x, y, z in excel how can I plot a curve with variable x, y, z in excel ... 20 Apr 2010 00:01 Defining areas on a graph I am working in a microbiology lab and am plotting on a bar chart zone size versus number of isolates. The size of the zone determines whether or not an organism is sensitive, intermediate or resistant to an antibiotic. I would like to be able to illustrate on the graph which area on it pertains to resistance/i... 19 Apr 2010 12:37 How can I select pivot table row totals to fill color them Ruth5155;937600 Wrote: I have a pivot table with total rows. Other people in my team at work can hover over the left edge of one of the total rows and all total rows get selected so that a fill color can be applied. It does not work for me ========================================================== h... 19 Apr 2010 03:17 how to creat dashboard how to creat dashboard in Excel? ... 19 Apr 2010 09:30 Charting scientific data - Excel 2003 Every once in a while I need to plot some spectral data. Because it's not very often and it's just simple plots, I can't justify to my boss the purchase of fancy and expensive plotting software programs (SigmaPlot, Origin, etc.). However, I can't figure out how to one thing in Excel: I have data with x being ... 20 Apr 2010 10:20 Excel Chart I am having trouble with Data points duplicating on my chart. I have 3 extra bars which duplicate the first in the series. I have checked the source data and it doesn't appear obvious to me. Please help. ... 16 Apr 2010 19:34 Line chart from data in 2 sheets Hi, Sheet2010 stores data for year 2010 Date Gross Net 1/8/2010 2076.92 1163.98 1/8/2010 5000.00 2862.51 1/22/2010 2076.92 1511.99 2/5/2010 2307.69 1302.92 2/19/2010 2307.69 1302.91 3/5/2010 2745.25 1566.36 3/19/2010 2884.62 1648.08 4/2/2010 2838.62 1621.31 4/16/2010 2884.62 1648.08 Sheet2009 stores d... 17 Apr 2010 09:41 Copying Excel 2007 Charts as picture (as seen on screen) The copy as picture (as seen on screen) function in excel 2007 seems to work for charts if doing it directly from Excel to other application. But if you try to code it in VBA, more often than not a chart or two disappears and does not copy to the designated application (e.g. Word). This is annoying. It works wh... 17 Apr 2010 15:13