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:


    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, Jul 18, 2013
    1. Advertisements

  2. KeriM

    KeriM Guest

    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, Jul 24, 2013
    1. Advertisements

Ask a Question

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.