Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Chart - missing Column
Hi,
I have created a pivot chart which I am running from a table of data outside the pivot table. I have created a chart with two axes which includes bar columns and a line graph, My table is like this. CON TRA MEE SUP TRA Category 1 Category 2 Category 3 Category 4 Count So I have a bars for each heading across the top, con, tra, mee, sup, tra, and there is a percentage in each of the 4 categories, when I plot the chart the first 3 categories populate the numbers in bars, however category 4 is plotting itself as a line instead, when I change this from a line chart type to a bar chart type the category 4 data is just not visible? It is also not visible as a line, it lies on the bottom of the graph. Can you advise how I can make the category 4 column visible? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing value in a pivot table | Excel Discussion (Misc queries) | |||
Missing Pivot Data in Pivot Field (PF)-Weird! | Excel Discussion (Misc queries) | |||
Cluster Column Pivot Chart | Charts and Charting in Excel | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
Excel - how do I show column grand totals on the pivot chart | Charts and Charting in Excel |