• 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.

How to show multiple categories in One Chart

K

kanchst

New Member
I am working on a project which has a data which looks something like this(Data attached in the image)
upload_2017-9-6_22-7-9.png
The data has % limit for different sectors for each month from jan to july for round about 40 sectors month on month(here just demonstrated 5) The percent utilization can be beyond 100% which means the sector is overutilised. All I want to show is that how is the movements becoming the sector i.e if the month on month movement is from 82%,83%,85%,89%(just for example) this is not so much alarming but is the movement is from 89%,90%,97%,101% this is alarming one because the sector is slowly and gradually moving towards the 100% limit and even crossing sometimes. All I want to show in an excel graph for all the 40 sectors. How is the month on month movement going on and where it is about to cross the limit of 100%. I tried this using multiple ways (bar, column) but all the graphs looks a lot cluttered. how can I show the month on month movement for each sector in one graph for all the 40 sectors.

Line, Bar , Column charts look a lot cluttered when I plot all the sectors together a plot the utilization. Also, For me what is more important is to highlight how can I show which sectors have a vast movement month on month but which sectors do not have.

Can anyone please help me on this.
 
kanchst said:
I am working on a project which has a data which looks something like this(Data attached in the image)
View attachment 45245
The data has % limit for different sectors for each month from jan to july for round about 40 sectors month on month(here just demonstrated 5) The percent utilization can be beyond 100% which means the sector is overutilised. All I want to show is that how is the movements becoming the sector i.e if the month on month movement is from 82%,83%,85%,89%(just for example) this is not so much alarming but is the movement is from 89%,90%,97%,101% this is alarming one because the sector is slowly and gradually moving towards the 100% limit and even crossing sometimes. All I want to show in an excel graph for all the 40 sectors. How is the month on month movement going on and where it is about to cross the limit of 100%. I tried this using multiple ways (bar, column) but all the graphs looks a lot cluttered. how can I show the month on month movement for each sector in one graph for all the 40 sectors.

Line, Bar , Column charts look a lot cluttered when I plot all the sectors together a plot the utilization. Also, For me what is more important is to highlight how can I show which sectors have a vast movement month on month but which sectors do not have.

Can anyone please help me on this.
Click to expand...
Hi ,

I came across this scenario but i am not sure this is your requirement. But i shared my file for your reference.
 

Attachments

  • Sample.xlsx
    17.1 KB · Views: 14
Syedali said:
Hi ,

I came across this scenario but i am not sure this is your requirement. But i shared my file for your reference.
Click to expand...
Hi Syed,

Thank you for your reply but I the bar charts will look a bit cluttered oncE I ave 12 months data
 
Hi ,

If you do not want to highlight one series , and want that all of 40 series should be prominent , and the chart should not look cluttered , that is impossible.

If you can upload the workbook , we can see if the data is clustered together ; if so , there is no chart which can 'unclutter' clustered data.

Narayan
 
You must log in or register to reply here.
Back
Top