LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default entering numbers but displaying percentage.

I want to create a chart from data similar to the following example:
x1 x2 x3
total 1000 500 750
a 250 100 375
b 300 200 100
c 200 50 180

On the chart, I want the Y-axis to show the amount but the data label inside
the chart to show the percentage each number is of the total (the top number)
in its column.

Possible? Difficult?

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying percentage sign in cell Feather 52 Excel Worksheet Functions 3 June 12th 07 06:46 PM
Displaying a percentage Timeferret New Users to Excel 5 August 14th 06 08:47 PM
Displaying percentage in ranges in pivot table pamarty Excel Worksheet Functions 3 May 10th 06 09:54 PM
Pivot Table (displaying data as a percentage) PJS Excel Discussion (Misc queries) 2 April 12th 06 02:06 AM
Entering and displaying fractions Chris Price Excel Worksheet Functions 1 March 9th 06 11:19 AM


All times are GMT +1. The time now is 01:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"