Numeric Value and Percentage Value in a graph

Kmitchell

Active Member
Joined
Feb 27, 2007
Messages
361
Office Version
  1. 365
Platform
  1. Windows
Hi There -- looking to create a column chart that would display both the absolute value and the percentage value in a chart. I'm not having any luck -- any suggestions?




Other$ Other % AAM$ AAM%
9/1/2008 3,914,723 46% 4,597,953 54%
9/1/2007 2,184,835 36% 3,966,829 64%
9/1/2006 2,029,604 37% 3,476,841 63%
9/1/2005 2,210,974 38% 3,581,566 62%
9/1/2004 770,035 18% 3,595,985 82%
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Concatenate (as text) the abs and percent value in cells in a separate column of the data and set the data labels to displlay the values in these cells by putting a formula for each data label.
 
Upvote 0
Thanks for the tip. How do I create a formula? When I concatenate it displays the percentage as an absolute value.
 
Upvote 0
To create the formula for a data label, select all data labels by clicking any one data label, then select the data label of choice by clicking it. In the formula bar type = and point to the cell (e.g. C10) whose text you wish to appear in the label. Do this for all data labels in turn.
 
Upvote 0

Forum statistics

Threads
1,214,979
Messages
6,122,551
Members
449,088
Latest member
davidcom

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