Results 1 to 8 of 8
  1. #1
    Lounger
    Join Date
    Apr 2001
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Line-Column Chart (Excel 2000)

    In my dataset, the column headings are dates. Row 1 is the number of open calls. Row 2 is the % of calls that are between 20 and 30 days old. Row 3 is the % of calls that are over 30 days old.

    I want a chart that has columns for the number of open calls (Row 1), and 2 lines - one for Row 2 and one for Row 3.

    If I choose the Line-Column chart type, it makes a column for the number of calls (Row 1), leaves a space for Row 2, and uses a line for Row 3. Apparently, it leaves a space because the data types of Row 1 and 2 are different and the poor thing is confused. How can I tell my little friend that I want Row 2 to be a line and not a column.

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Line-Column Chart (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Fern

    Oh boy Charts in Excel are nice, but very hard to understand and sometimes you do have to cheat <img src=/S/grin.gif border=0 alt=grin width=15 height=15> to get what you want.

    If you could attach a sample of your data, does not need to be real data, you can change the numbers or any identification data and I'll see what I can do for you.

    Also try and change the format to all numbers and then change the type of data charted on the chart itself.

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Lounger
    Join Date
    Apr 2001
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Line-Column Chart (Excel 2000)

    Hi Wassim. Thanks for responding. I have attached the file.
    I don't understand about changing the format and changing the data types. The format and data types have to be as they are for the chart to say what I want it to say.
    Attached Files Attached Files

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Line-Column Chart (Excel 2000)

    Hi,
    Does the attached look like what you want? Your second row was being plotted on the same axis as the first row and the values were too low to be seen. I've replotted them on the second axis and changed the chart type for that series to line.
    Hope that helps.
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Lounger
    Join Date
    Apr 2001
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Line-Column Chart (Excel 2000)

    Rory, that is EXACTLY what I want. I can see how to change the chart type for the series, but I can't figure out how to replot on the second axis. How would I do that?

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Line-Column Chart (Excel 2000)

    Select the series in question on the graph, choose 'Format' from the main menu then 'Selected Data Series...' which will bring up a dialog box. The second Tab is labelled Axis and this allows you to choose which axis to plot against.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    New Lounger
    Join Date
    Mar 2001
    Location
    Kansas City, MO
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Line-Column Chart (Excel 2000)

    I am using Excel 97 SR-2. I wasn't able to select the series that is not plotting properly and make the changes recommended. So I tried a variation on a trick that I remember reading in Excel 97 Expert Solutions. In order to make all of the plots appear, try placing two blank rows between the first row of data and the other two rows of data. Select the whole area including the blank cells and plot normally using the Chart Wizard. I used the column line combo chart type and everything plots our okay as seen in the attachment. The only catch is the Legend. Either do without one or clear the first blank legend key , then make the other invisible by selecting it and removing the color from its border and interior. Resize the legend border and Voila!! Note that I have not tried this solution in Excel 2000. Let me know if it works for you!
    Attached Files Attached Files

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Line-Column Chart (Excel 2000)

    Hi,
    Generally what I do if I can't select a data series manually (e.g. the values are too small and I can't see them) is to select one of the data series that I can see and then use the Up and Down cursor keys to scroll through the series until I find the one I'm looking for (the name of the series appears in the name box on the formula bar).
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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