Scatter Graph Help

Feb 28th, 2002, 01:21 PM

Hi I need help on the following problem I have a scatter graph with two sets of data, the highest performance is 7.50 and 1.731.

The lowest performance 61.34 and 3.138

I need to show a scatter graph in reverse order, so that lowest performance at the bottom of the graph and highest at the top.

My y axis run 0.000, 0.250 etc up to 37.50, 4000

My x axis run 0, 5 up to 60, 65.

Do I put a minus sighn in front of the data? and how will I show the axis?

or is that totaly wrong!!

Help please!!

Lizzy

Anne Troy · Feb 28th, 2002, 01:29 PM

Right-click on the numbers of your axis. Hit Format axis. Hit the Scale tab. Choose Values in reverse order.

Feb 28th, 2002, 01:29 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Right-click on the numbers of your axis. Hit Format axis. Hit the Scale tab. Choose Values in reverse order. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 01:21 PM	#1
Guest Posts: n/a	Hi I need help on the following problem I have a scatter graph with two sets of data, the highest performance is 7.50 and 1.731. The lowest performance 61.34 and 3.138 I need to show a scatter graph in reverse order, so that lowest performance at the bottom of the graph and highest at the top. My y axis run 0.000, 0.250 etc up to 37.50, 4000 My x axis run 0, 5 up to 60, 65. Do I put a minus sighn in front of the data? and how will I show the axis? or is that totaly wrong!! Help please!! Lizzy