+ Reply to Thread
Results 1 to 4 of 4

Add Line to Column Chart

  1. #1
    Forum Contributor
    Join Date
    10-14-2011
    Location
    London, England
    MS-Off Ver
    O365
    Posts
    180

    Add Line to Column Chart

    Hi,

    I have a boy / girl percentage column chart and I would like to put a line on showing the percentage from the other schools. I've drawn the red line on there manually - you can see what I mean here:

    https://snag.gy/g6k0M2.jpg

    Can I do this and if so, how?

    Thank you.

  2. #2
    Forum Contributor
    Join Date
    10-14-2011
    Location
    London, England
    MS-Off Ver
    O365
    Posts
    180
    Is this not possible then? That's disappointing

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,421

    Re: Add Line to Column Chart

    If you were to attach a sample file (as I keep reminding you), you might get a response. Honestly, images are next to useless. In any case, we need to see how the data is laid out.

    However, please remember that it is the Easter weekend, so activity here will not be as much as usual, and weekends are already quieter than weekdays.
    Last edited by AliGW; 04-01-2018 at 02:19 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,438

    Re: Add Line to Column Chart

    Add another series as xy-scatter.
    set correct x values and y values
    delete secondary axes

    add error bars to series
    delete y error bars
    format x error bars to have fixed value
    remove formatting of xy-scatter series line and markers
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to add target line to stacked column pivot chart chart
    By oleg mirzaev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-04-2013, 07:46 AM
  2. Replies: 1
    Last Post: 12-12-2012, 06:57 PM
  3. [SOLVED] How do I move a line marker on a line column combination chart?
    By dknj30 in forum Excel General
    Replies: 7
    Last Post: 05-08-2012, 09:21 AM
  4. How can I add a line chart in a stacked column chart style?
    By Guilherme Loretti in forum Excel General
    Replies: 0
    Last Post: 08-02-2006, 08:50 PM
  5. How do I add an extra line to a line-column chart?
    By moose in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-23-2006, 01:35 PM
  6. Line - Column Chart on 2 Axes - Line Not Appearing
    By Northpaw in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-22-2005, 11:01 AM
  7. Change Line Column Chart to Line Area chart
    By recchie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-23-2005, 11:40 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1