Conditional chart series.
If I have a table of data which has Date as column 1, Department as column 2
as Sales data in Column 3. (For example...) A B C 01/01/07 Dept 1 10 01/01/07 Dept 2 20 01/01/07 Dept 3 30 02/01/07 Dept 1 40 02/01/07 Dept 2 50 02/01/07 Dept 3 60 .... It doesn't have column headers as it stands. What I would like to do is have a chart with the Date (Column 1) as the 'X' axis, and 3 series, one for each Department (Column 2), against a 'Y' axis as determined by the number of Sales (Column 3). I'm using Excel 2003, but short of a Pivot chart I don't know how to do this. Further info, the reason I'm trying to use an ordinary chart is that I actually have more than 3 columns. as I have other data in my table which I would also like to chart, however I'm writing code to determine the data source for the series and doing this on a Pivot Chart I feel would be more difficult. I could refresh the pivot table data, then copy this out into a static data table where I have the Dept as column headers, but this seems a bit ineffecient to me and was hoping that I could do this another way. Any help would be great. TIA. |
Conditional chart series.
Several options:
Pivot table plus regular chart (http://pubs.logicalexpressions.com/P...cle.asp?ID=553) Conditional chart, requires additional columns (http://peltiertech.com/Excel/Charts/...nalChart1.html) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "DaveO" wrote in message ... If I have a table of data which has Date as column 1, Department as column 2 as Sales data in Column 3. (For example...) A B C 01/01/07 Dept 1 10 01/01/07 Dept 2 20 01/01/07 Dept 3 30 02/01/07 Dept 1 40 02/01/07 Dept 2 50 02/01/07 Dept 3 60 ... It doesn't have column headers as it stands. What I would like to do is have a chart with the Date (Column 1) as the 'X' axis, and 3 series, one for each Department (Column 2), against a 'Y' axis as determined by the number of Sales (Column 3). I'm using Excel 2003, but short of a Pivot chart I don't know how to do this. Further info, the reason I'm trying to use an ordinary chart is that I actually have more than 3 columns. as I have other data in my table which I would also like to chart, however I'm writing code to determine the data source for the series and doing this on a Pivot Chart I feel would be more difficult. I could refresh the pivot table data, then copy this out into a static data table where I have the Dept as column headers, but this seems a bit ineffecient to me and was hoping that I could do this another way. Any help would be great. TIA. |
All times are GMT +1. The time now is 01:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com