Multiple Charts from One Pivot Table (Excel 2000)
Posted by Jim Darcy on December 13, 2001 6:15 AM
I have my data summarized in a pivot table. One of the data elements has numbers much larger than the other five. I need to make a line chart, but due to the wide variance in data, I need to create two charts from the same pivot table (one for the product with large numbers, and the other for the rest of the data), otherwise the smaller quantity products get compressed and seemingly merged near zero - making the chart useless. I could do this fairly easily with the older version of Excel, but Excel 2000 doesn't seem to allow two independent charts to run off the same pivot table (changes made on one chart override the pivot table and therefore the second chart). Thank you!