Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel chart maximum series should more than 255 series | Charts and Charting in Excel | |||
How to display a series in chart table and not in the chart? | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
Conditional formatting of a data series in an Excel Chart? | Excel Discussion (Misc queries) | |||
Can I add an average series to a chart with 2 or more series? | Charts and Charting in Excel |