Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel (97)

    Sounds simple, but confusing without some data. Can you attach a small worksheet with sample data and describe again how the chart should look? TIA --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  2. #2
    New Lounger
    Join Date
    Jun 2001
    Location
    Connecticut
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Swap Axes in Excel (97)

    I'm trying to create a scorecard for a business. Is there a way to make the x-axis the value axis instead of the y-axis? Even better, can I create a graph with one horizontal axis that has left to right values of one to ten, perhaps a series, and a second series showing values between one and ten representing scores over time. Sample in Word 97 attached.
    Attached Files Attached Files

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Swap Axes in Excel (97)

    What do the sigma's and the set symbols mean? What about a simple column chart like one of the attached?
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Swap Axes in Excel (97)

    Have you tried changing the chart type from Bar to column? I'm currently using 2000, but I believe '97 works the same.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,469
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: Swap Axes in Excel (97)

    I think you want a stacked bar chart using a single data set...but I don't know how to do that, frankly.

  6. #6
    New Lounger
    Join Date
    Jun 2001
    Location
    Connecticut
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Swap Axes in Excel (97)

    They are actually Monotype sorts. They are markers and labels for the datapoints.

  7. #7
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Swap Axes in Excel (97)

    I don
    Attached Files Attached Files

Posting Permissions

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