Stacked Column Chart
I need to graph quartiles with the 3rd and 4th quartile falling below the 50th %ile line. The only way I can do this is to make the 3rd and 4th quartile be a negative #, but I do not want to have the negative sign displayed. Is there any way I can do this besides going into each data value on the chart and deleting the -sign? Because if I do that, the numbers will not update. In the attachment the first chart is what results when I create the chart, but the 2nd chart is how I would like it to look.
Use a custom number format on the data labels.
General;General;General
Detailed instructions
Select datalabels of series "Third Quartile"
CTRL+1 to display Format dialog
On Number tab select category Custom
In the Type box enter, General;General;General
repeat for Forth Quartile series.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks