Excel experts

[mrshandy]

Can this be done?

I have a line chart that has x data with percentages.

I want to add a line that has y data with large numbers (ranging 30K - 45K).

Is there anyway to combine the two into one chart? Like putting the axes on each side.

I'm open to different chart types if it can display the data.

Thanks!

[madisen]

You can create a chart with two y axes. Is that what you mean? You select both as series in your chart. Then highlight one of the series, either the % or the other, you can change the chart type once it's selected to a bar vs a line to differentiate it and then set it as the secodary. It will then be a second y axis on the right side of your chart with the other series as the y axis on the left side of your chart

[mrshandy]

May 21, 2015 11:56:00 GMT -5 madisen said:

You can create a chart with two y axes. Is that what you mean? You select both as series in your chart. Then highlight one of the series, either the % or the other, you can change the chart type once it's selected to a bar vs a line to differentiate it and then set it as the secodary. It will then be a second y axis on the right side of your chart with the other series as the y axis on the left side of your chart

Yeah I think that's what I want. Thanks. You rock! I'm going to look like such an excel badass to my boss.