Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Labelling bar graph-the bars in X-axis not via tthe legend

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MikeR-Oz - 02 Jan 2006 12:41 GMT
I have a simple bar graph with the Y- axis measuring vertically in units and
the X-axis a series of bars that show month 2004 then same month 2005
repeated  from november to july. The legend places the months/ year with a
colour code BUT I want to have the actual bar displaying the 2004 November ,
then next bar 2005 November and so forth through 2004/ 2005 July. At this
stage there is no actual labelling of each bar except for a legend of colours
and the Month/year detail.

Any help please.
Mike
JR - 03 Jan 2006 16:44 GMT
Right click on one of the bars and go to "Format Data Series", then go to
"Data Labels" and click "Show Label".  Then right click on one of the labels
and select "Format Data Labels".  This should give you what you are looking
for.

> I have a simple bar graph with the Y- axis measuring vertically in units and
> the X-axis a series of bars that show month 2004 then same month 2005
[quoted text clipped - 6 lines]
> Any help please.
> Mike
MikeR-Oz - 03 Jan 2006 22:26 GMT
JR, This is not what I require or at least if I followed your advise
correctly at least. I have a column graph with monthly data for 3 stores. so
each store for say November is displyed as a column next to the other stores
column etc -each column is in a different colour reflecting the different
store and the colour legend is to the left of the graph showing the name of
the store. What I would like is to get rid of the legend and have the name of
the store in the coloured specific store column or at least under it. Tis wat
instead of looking across to the legend to remeber what colour is what store
you have the name at the column. Does this make sense?

Mike

> Right click on one of the bars and go to "Format Data Series", then go to
> "Data Labels" and click "Show Label".  Then right click on one of the labels
[quoted text clipped - 11 lines]
> > Any help please.
> > Mike
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.