Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In a bar chart containing both positive and negative values, the X-axis
labels (indicated by the Category X series) display over the negative bars of the chart. Is there a way of moving the negative value labels to the right of the axis? I have seen this in both Excel 97 and Excel 2000. To reproduce, 1. Create a spreadsheet with the following in cells A1:B5: abc 100 def -400 ghi 200 jkl -150 mno -200 2. Select A1:B5. 3. Press the chart wizard button and choose a bar chart. 4. Click the FINISH button. I have seen a similar post for this issue for Works for Windows (Article ID : 113858). |
#2
![]() |
|||
|
|||
![]()
Hi,
This may help, http://www.andypope.info/tips/tip002.htm Cheers Andy Pearl Quan wrote: In a bar chart containing both positive and negative values, the X-axis labels (indicated by the Category X series) display over the negative bars of the chart. Is there a way of moving the negative value labels to the right of the axis? I have seen this in both Excel 97 and Excel 2000. To reproduce, 1. Create a spreadsheet with the following in cells A1:B5: abc 100 def -400 ghi 200 jkl -150 mno -200 2. Select A1:B5. 3. Press the chart wizard button and choose a bar chart. 4. Click the FINISH button. I have seen a similar post for this issue for Works for Windows (Article ID : 113858). -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
![]() |
|||
|
|||
![]()
Thanks for the information, Andy!
But is there anyway of actually displaying the labels to the right or left of the axis depending on whether if it is a negative or positive value? I would like the labels next to the axis without having to fiddle with the scale and the data on the graph is best suited for a bar chart. Can this be done? "Andy Pope" wrote: Hi, This may help, http://www.andypope.info/tips/tip002.htm Cheers Andy Pearl Quan wrote: In a bar chart containing both positive and negative values, the X-axis labels (indicated by the Category X series) display over the negative bars of the chart. Is there a way of moving the negative value labels to the right of the axis? I have seen this in both Excel 97 and Excel 2000. To reproduce, 1. Create a spreadsheet with the following in cells A1:B5: abc 100 def -400 ghi 200 jkl -150 mno -200 2. Select A1:B5. 3. Press the chart wizard button and choose a bar chart. 4. Click the FINISH button. I have seen a similar post for this issue for Works for Windows (Article ID : 113858). -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
![]() |
|||
|
|||
![]()
Hi,
Have a look at this. http://www.andypope.info/charts/posnegdlabels.htm Cheers Andy Pearl Quan wrote: Thanks for the information, Andy! But is there anyway of actually displaying the labels to the right or left of the axis depending on whether if it is a negative or positive value? I would like the labels next to the axis without having to fiddle with the scale and the data on the graph is best suited for a bar chart. Can this be done? "Andy Pope" wrote: Hi, This may help, http://www.andypope.info/tips/tip002.htm Cheers Andy Pearl Quan wrote: In a bar chart containing both positive and negative values, the X-axis labels (indicated by the Category X series) display over the negative bars of the chart. Is there a way of moving the negative value labels to the right of the axis? I have seen this in both Excel 97 and Excel 2000. To reproduce, 1. Create a spreadsheet with the following in cells A1:B5: abc 100 def -400 ghi 200 jkl -150 mno -200 2. Select A1:B5. 3. Press the chart wizard button and choose a bar chart. 4. Click the FINISH button. I have seen a similar post for this issue for Works for Windows (Article ID : 113858). -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I add values, labels and percentage for pie charts? | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
Is there a way to have two values (percent and number) in a label. | Charts and Charting in Excel |