|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
08-28-2008, 02:07 PM
|
|||
|
|||
|
Show Data Lables show Amount & Persentage at the same time
Hi All,
I have a graph which shows $ amount over a period of years. But I would like the Label on each bar in the graph to show not only the dollar amount, but also the % it represents of the whole for each year. If you don't mind, please see the attached example. In this example 2001 should show labels on the domestic sales as $4,02483, and would also show 84%. Does anyone know how to format a chart to show the label in these two different ways? Thanks for the help and ideas. 
|
|
#2
08-29-2008, 05:54 AM
|
||||
|
||||
|
You can link the data labels to cells, which contain all the information you want to display.
This addin does all the hard work for you http://www.appspro.com/Utilities/ChartLabeler.htm I have also tweaked your chart a little to illustrate an alternative to your current layout.
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sorting data based on time intervals | moonyboy99 | Excel General | 6 | 07-22-2008 07:23 AM |
| adding data for time interval | sabsay | Excel Programming | 0 | 03-17-2008 06:02 AM |
| Assignment overDUE PLEASE PLEASE HELP!! | undergrad | Excel Worksheet Functions | 2 | 11-29-2006 12:34 AM |
| Changing time format without losing data | lajones3 | Excel Miscellaneous | 19 | 11-21-2006 05:43 PM |
| time code data formatting | exceldoofus | Excel Worksheet Functions | 10 | 10-18-2006 04:44 AM |
Linear Mode
