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

Y.O.Y Comparison Chart - need help sorting

J

json

Member
Ok, so i have data from 2012 and 2013 that I am charting various aspects for a Quality Committee that I am on. Right now I have the 2012 Top 5 and the 2013 Top 5 in the same chart... 2012 columns first, then 2013. I have them showing from most frequent to least but i'v noticed that it is really only sorting the 2012 categories most to least and just using that same order for the 2013 data (but that same order is not correct for both years!!

I know i can create a chart for 2012 and a separate oen for 2013, but is it possible to have them on the same chart for room/layout reasons and still have them sorted properly?!

**due to work restrictions, I am unable to upload any files, so my apologies as i know this would be very helpful in this type of situation. I'll try to best explain my pivottable layout as much as possbile for anyone willing to help.

Thanks everyeone!!
 
Hi json,

What about creating the source of the graph manually? You could then order the series as you wish.

Cheers,
 
Thank for your reply!

I can move/"sort" them manually, but it keeps the same order for both years. however, this isn't accurate as they do not have the same TOP 5.

i think im going to try to create them separately and fake it.... seems like the only way
 
Can you download a file from work?

I uploaded a file with a quick example I prepared (quick and dirty :p) to check if I understand well what you want to do.

Could you please have a look and tell me if it is correct or how it should be?

Regards,
 

Attachments

  • Test_json.xlsx
    11.2 KB · Views: 17
thats pretty darn close to one of them... another one consists of 2 stacked column charts (year broken down by dept)

what sorcery did you use!?!

i also have a datatable for most chats.... im thinking this may play a big role in my problem
 
Last edited:
@json
Hi!
They're all alike, same genre, witches with strange and arcane dark and obscure powers...
Regards!

@Aurelie
Hi!
I did not do it... :rolleyes:
Regards!
 
Hi json,

I just organized the data in the source of the chart the way I want it to be displayed in the chart. Then I selected everything and inserted a bar chart. Nothing else, excel did the rest by itself :cool:
It is simple, but you need to understand how Excel plays with the series and put them together in a chart.

The problem of tables used as sources of a chart is precisely that you do not have so much flexibility in sorting the data. That's why sometimes the fastest and simplest way is just to organize your data manually.

I would advise you to have a look at the blog of Jon Peltier for some very useful tips on fancy charts: http://peltiertech.com/Excel/Charts/ChartIndex.html
He is definitely THE chart wizard in excel.
Or even on Chandoo's website you can find plenty of nice charts and explanations on how to do them.

@SirJB7, I did not want to be insulting by saying that Jon Peltier is THE chart wizard. I'm pretty sure you know a lot of magical formulas as well :)

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