Summary Chart

[#1]

Hey everyone,

I am working on this Action Items list where I want to kind of present a nice summary table.  I have an idea of how I want it to look but not sure where to start.  Any ideas.

Thanks

~Norman Rea

[Gysbert_Wassenaar]

Get the data first.

Next transform the data, if necessary.

Finally create the chart. It looks like a stacked bar chart will do the job.

[giakoum]

you could use a gauge chart for that

[#4]

A gauge chart sounds like the right idea.  So how can I get it to sum up the four areas based upon a due date?

[giakoum · Accepted solution]

something like the attached?

[#6]

I think that is going to work.  Of course I need to put all the nice pretty stuff on it but I see how you did it.

Thanks!

[giakoum]

Welcome!

the nice pretty stuff usually takes 90% of the total time

Good luck!

[Roop]

Or a guage like this ....?

[#9]

How do you recommend getting the labels on the bars and underneath?

[#10]

Actually I can live without the labels on the chart itself I can do text boxes.