Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Scatter Graph Help

  1. #1
    Guest

    Default

    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


  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •