best way to represent the chart

[geniusufo007]

Hi all,
is there any other best way to represent the percentage change graphically, i am using excel 2016, i have already shown this but i want best way to represent it
any help in this regard will be highly appreciated.

[MrShorty]

I don't know if I know the one best way to show your data, but I do know that every charting expert I have ever read has loathed 3D effects (one essay here: https://peltiertech.com/the-perils-of-being-in-3d/ ). Even if you decide to keep it as a column chart, I would recommend removing the 3D effect.

Much of the time, especially when the horizontal axis is time, I prefer a line chart over a column chart. I think it is easier to connect the data through time in a line chart.

What exactly are you wanting the chart to communicate? What does the column chart show that you like? What do you feel it is missing? Often times there is no answer to "the one best chart for the data". There are multiple possible answers and you almost need to try different charts, taking stock of each chart's strengths and weaknesses and eventually choose the one you like best.

[geniusufo007]

Thanks mr shorty for your best suggestion and also see a little a bit change

[MrShorty]

Looks good to me. Do you like the column chart? Do you feel it is missing something?