Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make a custom category axis?
I want to name the "0" marker on the category axis (i.e., TARGET) - instead
of "0" but leave the remaining values in place (i.e., 10, 20, 30). Is there a way to do this (i.e., -30, -20, -10, TARGET, 10, 20, 30, etc.) If not, is there a way to have the plotted color one color above the "0" and a different color below the "0"? |
#2
|
|||
|
|||
Replace the cell that contains the value 0 with the text TARGET.
-- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , "=?Utf- 8?B?TWF1cmVlbiBELg==?=" <Maureen says... I want to name the "0" marker on the category axis (i.e., TARGET) - instead of "0" but leave the remaining values in place (i.e., 10, 20, 30). Is there a way to do this (i.e., -30, -20, -10, TARGET, 10, 20, 30, etc.) If not, is there a way to have the plotted color one color above the "0" and a different color below the "0"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Axis display as category | Charts and Charting in Excel |