asked on

Change bar graph -

Hi,

I have a line graph plotted on a secondary axis

Can someone change the graph so that its a column graph that doesnt look really disproportiante

Thanks
EE.xlsx

Haris Dulic

Is this what you are looking?
EE.xlsx

Seamus2626

ASKER

Nope, i need the values to look more pronounced, not so small

Thanks

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Hello Seamus,

it would really help if you could describe in more detail what kind of chart you want. Use the drawing tools and mock up the chart. Then we know what to aim for and can tell you how to do it.

It's really hard to guess the desired outcome, so, please help us help you.

cheers, teylyn

Seamus2626

ASKER

So, you can see where i added the blue box to the chart, i would like a big label in that saying 1.28% and the bar next to it saying 27.89% and then i could colour the Y axis white & the graph would be much more presentable

Thanks
EE.xlsx

ASKER CERTIFIED SOLUTION

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Glenn Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Seamus2626

ASKER

Thanks guys!

Jon_Peltier

The only problem with this solution is that most people will not get the dual axes at first, even with different color labels. Some won't really get it any time. Interleaving of columns that link to opposite axis scales is a sure way to make the chart hard to understand.

The clearest thing to do here is make a panel chart or use two separate charts, one above the other. Here is a quick tutorial showing how to make a panel chart with similar data:

Easy Two-Panel Column Chart in Excel