Overlay line graph points on bar graph

Discussion in 'Excel Charting' started by KeriM, Jul 18, 2013.

  1. KeriM

    KeriM Guest

    I have some data that I have in a bar chart, but I need two serie
    labels to be graphed as a line graph marker overlayed on the bar chart
    Here is a sample worksheet:

    http://tinyurl.com/nygxjto

    The "goal score" and "mean" correspond to the 2013 data. I need thos
    two series labels as line point markers (with no connecting line
    overlayed on the 2013 data bar under the corresponding categories a
    shown in the data sheet.

    I'm not sure how much sense I'm making, so please let me know if I nee
    to elaborate. Any help is appreciated! Thank you


    --
    KeriM
     
    KeriM, Jul 18, 2013
    #1
    1. Advertisements

  2. KeriM

    KeriM Guest

    KeriM;1612791 Wrote:
    > I have some data that I have in a bar chart, but I need two serie
    > labels to be graphed as a line graph marker overlayed on the bar chart
    > Here is a sample worksheet:
    >
    > http://tinyurl.com/nygxjto
    >
    > The "goal score" and "mean" correspond to the 2013 data. I need thos
    > two series labels as line point markers (with no connecting line
    > overlayed on the 2013 data bar under the corresponding categories a
    > shown in the data sheet.
    >
    > I'm not sure how much sense I'm making, so please let me know if I nee
    > to elaborate. Any help is appreciated! Thank you!


    I've actually figured this one out on my own. I used this:
    http://peltiertech.com/Excel/Charts/BarLineCombo.html as a guide.

    The "paste special" part was tripping me up, but once I realized that
    couldn't use keyboard shortcuts and I had to go to the menu bar optio
    to use the command, I didn't have any more problems.

    I also had to flip his data around since my data is organized verticall
    and his is organized horizontally. After the paste special, I had t
    choose "Values (X) in Columns" instead of "Values (Y) in Columns" lik
    he has.

    I also had to add my placeholder data along the bottom to line up wit
    my vertical data.

    If anyone is using this as a guide, I can post my solution in a workboo
    if requested


    --
    KeriM
     
    KeriM, Jul 24, 2013
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Laurie M

    changing a line to a bar in "line-bar graph"

    Laurie M, Sep 5, 2003, in forum: Excel Charting
    Replies:
    1
    Views:
    152
    Jon Peltier
    Sep 5, 2003
  2. Molly M

    how to add overlay line chart to stacked bar

    Molly M, Oct 4, 2003, in forum: Excel Charting
    Replies:
    1
    Views:
    133
    Debra Dalgleish
    Oct 4, 2003
  3. Pedro

    double graph overlay

    Pedro, Aug 20, 2004, in forum: Excel Charting
    Replies:
    4
    Views:
    119
    Bernard Liengme
    Nov 4, 2004
  4. elephrunner
    Replies:
    2
    Views:
    269
    Jon Peltier
    Oct 9, 2004
  5. SMAAngel
    Replies:
    4
    Views:
    823
    MJSlattery
    Nov 5, 2004
  6. Violet Maven
    Replies:
    1
    Views:
    130
    Barb Reinhardt
    Jul 12, 2005
  7. MikeR-Oz

    Bar graph and line graph overlayed

    MikeR-Oz, Jan 2, 2006, in forum: Excel Charting
    Replies:
    4
    Views:
    203
    MikeR-Oz
    Feb 6, 2006
  8. jk9533
    Replies:
    4
    Views:
    220
    Jon Peltier
    Jul 9, 2008
Loading...