Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chance224
 
Posts: n/a
Default Bar Graph with unique column labels

I have a bar graph that has three columns; Cost Revenue, & Profit. I would
like to have the cost column have a label show on top of each bar that shows
the percent of cost. I have the needed values in a cloumn on the spread
sheet. These three columns represent each day of a cartian project.




  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

Chance,

One way - this example shows how you can add two labels per one set of
columns. Since your graph has three sets of columns, you will need to adapt
the technique to add three columns instead of one.

http://www.pdbook.com/index.php/exce...ls_per_column/

If you are only displaying only label per column, another option is to add
data labels that are independent of the data series. These tools will help:

(1) You can use Rob Bovey's XY Chart Labeler add-in located at:

http://www.appspro.com/Utilities/ChartLabeler.htm

(2) You can use John Walkenbach's Chart Tools add-in located at:

http://j-walk.com/ss/excel/files/charttools.htm

You can view a more complete explanation he

http://www.pdbook.com/index.php/exce...t_data_labels/

----
Regards,
John Mansfield
http://www.pdbook.com

"Chance224" wrote:

I have a bar graph that has three columns; Cost Revenue, & Profit. I would
like to have the cost column have a label show on top of each bar that shows
the percent of cost. I have the needed values in a cloumn on the spread
sheet. These three columns represent each day of a cartian project.




Reply
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
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Align Clustered Column Chart Category Axis Labels Stephanie Charts and Charting in Excel 1 April 7th 05 03:21 PM
restoring column labels Excel 2002 Paul B Excel Discussion (Misc queries) 3 April 6th 05 09:29 PM
Counting unique entries in column A but only if specific values appear in columns B and C markx Excel Worksheet Functions 1 February 10th 05 11:52 AM
find rows for unique data in 1 column and different data in other. Dot Majewski Excel Discussion (Misc queries) 1 January 21st 05 12:23 AM


All times are GMT +1. The time now is 09:43 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"