Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: A Line-Column Chart: How do I specify which series should be

  1. #1
    Guest

    Default

    I have been trying to make a chart that shows one data series as a Line. Then I want to add 2 or 3 data series as Columns. However, Excel chooses arbitrarily which data series to make Column or Line. I seem to have no choice in the matter. How do I choose?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well, you DO have a choice.

    Click on the serie that you want to be a column, and in the chart toolbar, select that chart type. Now, select the other serie, and do the same, but this time select a line type.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Guest

    Default

    You are the Man! Thanks!!! It worked!

Some videos you may like

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
  •