View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JR
 
Posts: n/a
Default Labelling bar graph-the bars in X-axis not via tthe legend

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.

"MikeR-Oz" wrote:

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