I have a scatter chart with both the X and Y axis having a value from 0 to 5. I need the Y axis to go from 0 to 5 (which works and is the standard low to high number) but I need the X axis to go from 5 to 0. If I make the X numbers -5 to 0 I can get what I want on the graph but I really want the numbers to show as positive numbers. How can I do this?
Try putting the value #,##0;#,##0 in the Format Pattern field of the Number tab of the Scatter Chart Properties for the expression that is on the x-axis.
