Raw Numbers and Percentages in same chart?

Mary in Colorado

New Member
Joined
Apr 19, 2005
Messages
11
I was wondering if there is any way to create a chart that has columns representing raw numbers, but then select Data Table and have the percentages displayed?
I know how to create a combination chart, but the format that is desired for this report is to show numbers and percents together in the same graph if possible.
Thanks!
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
You could add the percentages as a new series, change it if necessary to a line series, then hide it by formatting it to have no lines and no markers. This will appear in the data table.

Or you could build a custom data table, either in the cells near the chart, or in any range somewhere else. You can add any information you want, and format it however you want. Then use the camera tool to copy the table and place it where you want it.

The camera tool button can be added to a toolbar like this: Tools menu > Customize > Commands tab, choose Tools in the left hand list, find the Camera tool on the right, and drag it to a convenient place in the toolbars.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

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