Looking for a way to add second column fro pivot table to char without adding new bars to graph

timk5000

New Member
Joined
Feb 29, 2016
Messages
8
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.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,213,553
Messages
6,114,279
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top