Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
create line chart with two axises in Pivot Chart
Hi,
I want to show two data series: Sum of Turnovers and Sum of Turnover Assets in the pivot table simultaneously in the pivot chart. When I use a line chart, the data points from two series are just connected into one line. Even if I select Chart Type to be Line with Two Axises, it doesn't help. I could, as a compromise, use column charts which does show the data points separately, but they are all in the same color. I could also change individual colmn's color, but that's too laborious... Any help is appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
create line chart with two axises in Pivot Chart
If you are seeing a single series, then the datapoints are adjacent in the
spreadsheet. You need to have the Sum of Turnovers and the Sum of Turnover Assets laid out differently in the pivot table. Drag the Data button of the pivot table to the Column area of the pivot table. -- Cheers, Shane Devenshire "HuaXC" wrote: Hi, I want to show two data series: Sum of Turnovers and Sum of Turnover Assets in the pivot table simultaneously in the pivot chart. When I use a line chart, the data points from two series are just connected into one line. Even if I select Chart Type to be Line with Two Axises, it doesn't help. I could, as a compromise, use column charts which does show the data points separately, but they are all in the same color. I could also change individual colmn's color, but that's too laborious... Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
how do create a line/scatter chart | Charts and Charting in Excel | |||
How do I create a Line Chart (Special) | Charts and Charting in Excel | |||
How to Chart XXY axis with different X axises | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |