Can anyone Replicate this in excel!

[Amit Punia]

PFA

 

[ThrottleWorks]

Hi @Amit Punia , could you please explain in details what are your requirements.

Are you looking for creating a chart in excel or do you want to paste chart as image in your excel sheet.

Sorry, was not able to understand your requirement.

 

[bobhc]

Why not use a cluster chart?
Upload some data in Excel, word is no good, then we can see what it is you have and what you want.


Post moved to correct section


.

 

[Amit Punia]

I'm using the 2-D Bar in Insert Tab. It is showing the chart just like this. Able to show the "Data Labels"(Ouside End) through "Add Chart Element". But if you see the image properly, you'll come to know that the Data Labels are in number format and the "Primary Vertical Axes" are in Percentage format. How to do that?

 

[bobhc]

But if you see the image properly,

I do believe the picture was looked at properly

you'll come to know that the Data Labels are in number format and the "Primary Vertical Axes" are in Percentage format. How to do that?

Pity you did not take the time to explain fully what you had done and what you wanted.

Upload some data in Excel

.

 

[NARAYANK991]

Hi ,

If you want to show a value of 40 as 40% ( unlike a genuine percentage value where 40% will actually be 0.4 ) , all you have to do is choose a Custom Format of 0"%".

Narayan

 

[Steph.]

Hi guys,

I am quite sure there are, as often with Excel, many solutions to your problem.

To have the labels in "number" format (not in %) and keep the axis in % format, I add an other column to the datas.

Then, select the first label, then click in the formula bar and type =, then click the cell you want to refer to.

Repeat this operation for each data label.

Regards from Paris,

Steph.