plz help me to fix the Cluster Chart

[Paul Cherian]

Hi Experts,

I have done a Cluster chart but it is not inline with my requirement. Can you please have a look at the excel sheet where you can see the data and chart along with the screen shot of my expectation.

Please its urgent.

Regards
Paul

[Kaper]

See attachment.
On original graph I clicked one by one each of three "lower" series and formatted them to be displayed on secondary axis.
It does not look good, but now (see graph copied below original) I just selected secondary axis and deleted it.
Better, isn't it?
Then (see another copy below), I formatted one of series drawn on main axis to have a 100% gap, and then did the same (formatted to have 100% gap) with one of series from secondary axis

[Paul Cherian]

Hi Kaper,

May thanks to work on this. But i tried to follow your steps. But could not succeed. Step 2 onwards i am bit confused. Can i have your skype to see it live.

Thanks and Best Regards,
Paul C

[Paul Cherian]

Hi Kaper, Could you please explain the step 2? "I just selected secondary axis and deleted it". from which copy u did it? If you delete the secondary axis then how you will see secondary axis on the 3rd copy?

[Paul Cherian]

Dear Kaper...!

Many thanks for your suggestions. Now i could do the chart with a simple technique.

Step 1: As you advised.
Step 2: I clicked on the "Add chart element" from the Design Tab. (You should click on the chart to see the tab on main menu)
Step 3: From 1st option "Axes" i selected "Primary Vertical"
Step 4: As you said both Primary and Secondary gap set to 100%

Done!

Thanks Again :-)

[Kaper]

Hi,

Glad to hear that, and thanks for marking thread as Solved.

It would be lovely if you colud also "add some reputation" to those who helped (me?) by clicking a small star icon in lowerleft corner of our/my post(s). (and confirming that "you agree").


Best Regards,