Excel 97 Chart
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Excel 97 Chart

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Help!! The x-axis on a simple chart of two data columns keeps defaulting to categories 1 thru 5 instead of using the x-axis values. It does pick up and use the y-axis values. How can I get the chart to use a range of x-axis values on the horizontal axis instead of just the category numbers of 1 thru 5? Thanks.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How's your data organized? What's your chart's SERIES function look like?

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    The data series are below. When the graph prints, the speed values are plotted with speed on the y-axis. But the x-axis only has the label "weight, lbs." and the numbers along the x-axis are 1, 2 3, 4, 5 instead of a range incorporating the actual weight values. Any suggestions? Thanks.
    Weight, Lbs. 5 7 13 15 23
    Speed, Ft/Sec 3.07 2.73 2.47 2.13 2.01

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
  •  

 

 
DMCA.com