I'm hoping to show a graph with positive and negative values, but I hate what it looks like when the zero is in the middle of the axis. What I'd like to do is show negative values going in the same direction as the positive values, but with inverted colors (which I know how to do). The only problem is that I need data labels as well.
Please help, thank you!
Could we have some sample data in a workbook?
BSB
I always thought this was as simple as setting the "horizontal axis crosses at" property of the vertical axis to something suitable. Since "at axis minimum" is not one of the options, you would simply choose a value smaller than the smallest value you would ever expect to see.
Originally Posted by shg
Is this anywhere near what you need?
It uses a couple of helper columns that could easily be hidden away.
BSB.
This is a great start, but I need to display data labels, so i don't think this will work :/
I'm not sure why BSB's suggestion prevents you from adding data labels? I can add data lables just fine. The columns that would correspond to empty string "" show up as 0 in the data label, but this can be controlled by using a number format that suppresses the display of 0's. Using NA() (to return the N/A error) instead of "" also seems to suppress the display of data labels at those points.
If this is what you are looking for, perhaps you can explain what difficulty you are having in adding the data labels.
Sorry, should have been more clear. I need data labels that show the negative value. ie - "-15" instead of "15"
How about using a secondary axis and reversing its order?
See Sheet2 in the attached.
BSB
Absolutely genius. I love this forum.
Happy to help.
Format the data labels as Custom and add #"" to the list to suppress the zero values showing.
BSB.
I'm actually using percentages without decimals, so these all rounded to zero and thus disappeared. Any solution to that?Happy to help.
Format the data labels as Custom and add #"" to the list to suppress the zero values showing.
BSB.
Have you tried MrShorty's suggestion of using NA() to suppress zeros rather than the formatting method?
Difficult so suggest anything else without seeing the file.
BSB
The NA() did not work unfortunately. It actually displayed the #N/A
Hmmmm... Stumped by that one for the time being I'm afraid.
I shall have a think about it and come back if I work it out.
BSB.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks