| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Chart
I wish to create a pivot chart line graph that has two lines, one line being
the 2007 value and one line being the 2008 line. The data is in two tables. I sort of figured out how to create the pivot table from two sets of data, but I can't figure out how to get the chart to have two lines. Ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Chart
Can you combine the data into a single table, with one column for 2007 values
and one for 2008 values? Then you could chart right from the single pivot . .. . "Mike H." wrote: I wish to create a pivot chart line graph that has two lines, one line being the 2007 value and one line being the 2008 line. The data is in two tables. I sort of figured out how to create the pivot table from two sets of data, but I can't figure out how to get the chart to have two lines. Ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Chart
I will try that. I did come up with a way to do it without using pivot
tables at all, but let me give that a try too. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create chart from Pivot table but not Pivot chart? | Charts and Charting in Excel | |||
| When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
| Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
| Maintain colour changes in a Pivot Chart when changing Pivot value | Charts and Charting in Excel | |||
| How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) | |||
Linear Mode
