putting two data values in a chart

alvarito

New Member
Joined
Jul 11, 2002
Messages
23
I am able to create a chart (graph) from data in a spreadsheet and do a show values making it display the value at each point on the graph. But, what I can't do, or don't know how to do, is to add a second value at each individual point. For example. If point one on the graph has a value of 20 and it displays 20 on that point but that point is also 30% of the total capacity, I would also like to add above the 20, or somewhere, the 30% so I can see both values when I look at the graph. Is there a way to do this? Thanks for the help.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
why not simply create a second data series that calculates the percantage of each element in the orignal series, then plot the % series on a secondary axis?

Paddy
 

Forum statistics

Threads
1,148,193
Messages
5,745,263
Members
423,941
Latest member
CluelessAboutExcel

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
Top