• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Correct to use Stacked Column Chart to Reflect Events and Claims?

KC E

Member
Hello,

I couldn't see how to post an introduction on the Introduce Yourself screen, but I am in the United States and glad to see that this forum and site is here. It has been helpful.

I use Excel 2010 and sometimes don't know which chart type to use.

I would like to know if it is correct to use a Stacked Column chart to reflect the # of events and # of claims, like in insurance, where there can be 1 event (an accident) and 1 or more claims (injuries reported) as a result of the event.

Excel says use a stacked column chart to calculate the contribution of a value to a total. I'm just trying to show how many events and how many claims and know that I could just use a Column chart with 2 columns, but want to know if a Stacked Column chart is also appropriate.

Thank you for your help.
 
Good day KC E and welcome to the forum, please read this link it will help in your use of the forum.

http://chandoo.org/forum/forums/new-users-please-start-here.14/

The above link will also allow you to introduce yourself

This link is a list of the Chandoo forum sections, by posting in the most relevant section you will get better results as members have different Excel skills and do not trawl through all posts.

http://chandoo.org/forum/

As to your question, the choice is yours as to the chart you want with the exception of a pie chart. they tend not to be good at presenting smaller percentages, the slices of the pie all look the same (this is my humble opinion)...(but true).

You could play around with the chart types until you are happy with the look, and the way others see the data, don't for get you are constructing the raw date sheets and the charts, you know what it should look like and what is needed those who are to receive your master piece don't know!!

One way of helping yourself is to use the upload button and upload the work sheet, if it contains sensitive data remove it and put working rubbish (crap) in its place.

You may find this link of use.

https://support.office.com/en-gb/ar...103-9e0a-27cdb19afb90?ui=en-US&rs=en-GB&ad=GB

This will give your eyes a work out but shows how different charts display.

https://www.google.co.uk/search?q=t...IyzCdLgar7cgOAN&ved=0CDgQsAQ&biw=1430&bih=752
https://support.office.com/en-gb/ar...103-9e0a-27cdb19afb90?ui=en-US&rs=en-GB&ad=GB


.
 
Hi ,

Normally , a stacked column chart is used where the quantities being charted have a direct relationship , from which you draw certain conclusions , or where you wish to show their progress over time.

For instance you might want to show how sales and number of customers have varied over time , or how profit margins have reduced even as sales volume has increased over time.

If either of these hold in your case , you can certainly use the stacked column chart , though in your specific case , there are probably better alternatives. See this link for more :

http://peltiertech.com/tornado-charts-and-dot-plots/

If you are looking for how to decide on a chart to display your data , you might find these links helpful :

http://labs.juiceanalytics.com/chartchooser/index.html

http://www.labnol.org/software/find-right-chart-type-for-your-data/6523/

Narayan
 
Thank you both very much. I appreciate your help.
Thank you, Narayank991, for your explanation. It helped cement what stacked column charts can be used for.
I will look through each of your links. (I don't have internet at home, so I will have read them as I am able.)
 
Back
Top