If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Labelling bar graph-the bars in X-axis not via tthe legend
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Labelling bar graph-the bars in X-axis not via tthe legend
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 "JR" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want graph with 2 axis, but bars overlap when second axis added | Gill | Charts and Charting | 4 | October 15th, 2005 02:21 PM |
2 axis bar graph | Steve | General Discussion | 3 | March 29th, 2005 11:06 PM |
Graph Legend | Alan | New Users | 1 | July 13th, 2004 06:17 PM |
Two Y axis in Graph | Debra Dalgleish | Charts and Charting | 0 | March 20th, 2004 09:39 PM |
force graph to axis of choice | Tushar Mehta | Charts and Charting | 3 | February 11th, 2004 04:04 PM |