Overlay line graph points on bar graph


K

KeriM

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
 
Ad

Advertisements

K

KeriM

KeriM;1612791 said:
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
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top