Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Help with Graph (XL 2003)

    I need to graph two data sets on one graph and need some advice / help. I am trying to show a correlation between the number of inventories a business performs and the profit percentage. The thinking is that a business that is more concerned with their product (# of inventories) will perform at a higher level (better profit %).

    I've attached a set of sample data. It shows six business locations, the number of inventories for each, and the profit percentage for each. I want to show the data on a graph.

    Using a line graph, the y axis could have points for each store location, while the x axis could reveal the number of inventories - that's simple enough. But then I would need a second x axis to represent the profit percentage for those locations. The ending graph would show two lines (one for inventories, the other for profits); the lines would move up and down at roughly the same spots. Of course, I can't have two x-axis's on one graph...

    Any ideas?
    Attached Files Attached Files
    - Ricky

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help with Graph (XL 2003)

    I think you mean that you want the stores on the x axis (category axis) and the data on the y axis (value axis). You *can* have two different y axes (and you can even have two different x axes but that's not necessary here).

    - Create a line chart based on B511; the default settings will do for the moment.
    - As you'll see, the YTD Profit% series will be very near the x axis because its values are much lower than that of the Inventories series.
    - Click once om the YTD Profit% series to select it.
    - Select Format | Selected series...
    - Activate the Axis tab.
    - Select Secondary axis.
    - Click OK.

    See attached version.
    Attached Files Attached Files

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Thank You

    Awesome! - Now, I know how to bring in the 2nd axis.
    Don't know why, but I had no idea the Format menu changed depending on the selection. I always thought that right-clicking the selection was the best route to formatting and properties.

    I changed the scale on the 2nd axis to a minimum value of 0.15 (15%) and the maximum to 0.29. Seems more appropriate that both lines would fill the chart area. I appreciate the push.
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Thank You

    There are three ways (at least) to get to the Format Series dialog:
    - Left-click on a series, then select Format | Format series...
    - Right-click on a series, then select Format series from the popup menu.
    - Double-click a series.

Posting Permissions

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