negative and large positive values not showing correctly in an Excel chart

I will have a look for you, however don't tell us that it is URGENT, please. To you it may be, but to us it isn’t. If it’s urgent, you should be calling on a consultant, not a volunteer who is giving their free time.

OK - I have had a look. You have given us three columns of data, but nowhere do I see any indication of what you would consider "a decent-looking chart" mocked up. We are NOT mind-readers: there are literally thousands of possibilities. What sort of chart do you want and what story do you want it to tell?

Please respond to post #3.

Thank you! Would the Column chart be perfect? Basically, want to visualise the difference column for all those categories ideally comparing those years , 2019 and 2018.

Values of change between years (col 3) comparing to values on years are too small to presents them on with the same Y-Axis, so I suggest to use secondary Y Axis and chart can looks like this:
Of left Y axis is related to 'main' values from years, right Y axis is related to difference between them and has its own 'scale'. As you can spot 0 on right does not mean 0 on left, so this kind of presentation have to be 'read' correctly.

Thank you but I want to show negative values as well as used in the following link.
https://www.wiseowl.co.uk/blog/s311/excel-charts.htm
Can We get similar to the one shown as "Rating"?
I really appreciate your help!

the best possible chart type for this type data

There's no point asking for this: it's an entirely subjective thing and there could be thousands of interpretations.

Stick to what you showed in your previous post - someone should be able to help you achieve that. I'm not big on charts - sorry.

There is too huge difference between MAX of change and MIN of change (max is over 50 times bigger) to expect that columns of these values will be visually comparable.
With this difference max takes 98% of chart height and min only 2%. Are you follow my explanation.
C is the smallest value to display (the biggest negative), H is 50 times bigger as value (ignoring +/-).
Attachment 742153

You can also try to generate 2 charts, 1 for years and 2nd separately for changes, set transparent background for 2nd and cover it. When you correctly set everything it can shows something similar to this:

Capture.PNG

Thank you! I can't open the attachment(Attachment 742153). Is there a way to use log scale for positive as well as negative values? I think Log scale might help to show the bars with some reasonable height. Any help is much appreciated. I thank everybody who has given their valuable time and knowledge.

Consider displaying data in smaller portion (in my example by 3).
However there is still be an issue that there are huge differences between values and if C looks fine here comparing with A and B:

Capture.PNG

then in comparison with D does not look so impressive here:


1.PNG

you can spot that there is still the same value displayed -7500 (scale is in thousands).

you can use slider below to displaying data by 3 (ABC, BCD, CDE etc.)

I would change the pie chart to a 2D version - 3D charts are 'pretty', but tend to give a distorted impression of the relative sizes of the segments, in the case of a pie.

Fully agree with AliGW. Question is what is more important. What have to be expose on chart, etc.
Changes as AliGW said, better presents as % not value.
For me even chart like this is quite interesting, if I know what I am looking on it.