Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Location
    Dallas, Texas, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Line - Column Chart-I need two lines, not just one (Excel 2003)

    I need assistance with a chart I have been asked to do. Basically, it is a form of the Line - Column chart on the "Custom Types" tab for Excel charts. I have attached an example of what I need to do. I am trying to show three types of data. First, there are Bookings, which I want in a bar. Second, I want Goal as a line, and Stretch goal as another line. But when I try to do a Line - Column graph, I can only manage to get one line on the graph, which right now is the Stretch data. They are all on the same axis, so I don't need to do the two-axis chart.

    Does anyone have any idea how this might be done?

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

    Re: Line - Column Chart-I need two lines, not just one (Excel 2003)

    Click once on the Goal series. All columns in this series will be highlighted.
    Select Chart | Chart Type...
    Select the Line Chart type.
    Make sure that "Apply to selection" is ticked (this is the default setting)
    Click OK.

    This way, you can set the chart type for each series separately.

  3. #3
    New Lounger
    Join Date
    Sep 2003
    Location
    Dallas, Texas, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Line - Column Chart-I need two lines, not just one (Excel 2003)

    THANK YOU! This does exactly what I want!

Posting Permissions

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