I would like to some how put 2 information from 2 columns in a pitor table on 1 bar graph.
My pivot table is simple
Column 1 Column 2
JAN .00023 23
FEB .00043 22
MAR .00033 21
Column 1 each row is a Average based on a months data
Column 2 each row is a Count of the rows included in each months data. This is actually the number of days included in the total for the month.
I have a simple bar graph built on this pivot table.
The Bars on the chart represent the number in column 1 of the pivot table. Each month has its own vertical bar on the graph.
I would like some way of placing the number in column 2 of the pivot table above, or inside the corresponding bar in the chart. Even if I could append the number to the Label in each Bar on the Graph.
I do not want to add bars to the chart for the data in column 2, I just want to put the data above the bar for the month.
I want the user to look at the bar graph and be able to See the value for each month and be able to see how many work days mad up the value.
Any one have any Ideas.
My pivot table is simple
Column 1 Column 2
JAN .00023 23
FEB .00043 22
MAR .00033 21
Column 1 each row is a Average based on a months data
Column 2 each row is a Count of the rows included in each months data. This is actually the number of days included in the total for the month.
I have a simple bar graph built on this pivot table.
The Bars on the chart represent the number in column 1 of the pivot table. Each month has its own vertical bar on the graph.
I would like some way of placing the number in column 2 of the pivot table above, or inside the corresponding bar in the chart. Even if I could append the number to the Label in each Bar on the Graph.
I do not want to add bars to the chart for the data in column 2, I just want to put the data above the bar for the month.
I want the user to look at the bar graph and be able to See the value for each month and be able to see how many work days mad up the value.
Any one have any Ideas.