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

Charting multiple variables

sarinky

New Member
Dear everyone,
I have a problem when i created a chart with many variable. I wanted to present in a bar chart which on the X-axis there are groups and in each group there are two different data. On the otherhands, I had other category name represent each data and I want to display those category names on the bar chat. Can anyone help me to deal with this. Currently I am doing mannually.
I attached with a sample workbook.
Kind Regards,
Sarin
 

Attachments

  • Chart Sample.xlsx
    16.9 KB · Views: 4
Sarinky

Firstly, Welcome to the Chandoo.org Forums

Have a look at the attached
change the Drop Down in B1 and it should all change as required
 

Attachments

  • Chart Sample.xlsx
    15.4 KB · Views: 14
Back
Top