Data labels along below x axis when y axis has negative values
in [Charts]
|
From: Andrew on 3 Jul 2008 14:11 Hi, I created a stacked column chart where my y axis has values ranging from 700k to -700k. For each column I have a label displayed along the x-axis. However, by default the labes are displayed just below 0 on the x axis (right in the middle of the chart). If a charts scale ranges from 0 to > 0 the labels are displayed outside of the chart by default...not the case when the y axis scale has negative values. I double clicked on the values and went to the alignment tab but could not get the vales to offset low enough so that they are outside of the graph (ie- under -700k on the y axis). How do I display the labels outside of the grey shading on the graph when my y axis has negative vales?
From: Andy Pope on 3 Jul 2008 15:36 Hi, Set the label position to Low. http://www.andypope.info/tips/tip002.htm Cheers Andy Andrew wrote: > Hi, > I created a stacked column chart where my y axis has values ranging from > 700k to -700k. For each column I have a label displayed along the x-axis. > However, by default the labes are displayed just below 0 on the x axis (right > in the middle of the chart). If a charts scale ranges from 0 to > 0 the > labels are displayed outside of the chart by default...not the case when the > y axis scale has negative values. > > I double clicked on the values and went to the alignment tab but could not > get the vales to offset low enough so that they are outside of the graph (ie- > under -700k on the y axis). > > How do I display the labels outside of the grey shading on the graph when my > y axis has negative vales? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
Pages: 1 Prev: ======> Secret Video CLIPS <========= Next: Horizontal axis with its real value |