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

Chart

GN0001

Member
I have a data table as below


2010 category 1 category 2 category 3

type a 4 5 6

type b 4 4 12

2011type c 44 12 33

type a 12 14 44

I want to insert a chart for this data. What is the best chart for this data?

Can I insert a chart for year that cover the area of the chart and then make another chart for the rest of data and copy it and paste it to first chart?


How about the chart that Hui made for the age of excel user that has something in background?


Please advise me and many thanks,

Guity
 
Have a quick look at

http://rapidshare.com/files/455233526/Guity_Mar10.xlsx

for some ideas

I've posted about a dozen different ideas

Also rearranged the data and added it to a Pivot Chart with a slicer

Its so much more flexible


The Excel Age charts are simple charts using named ranges, nothing fancy!
 
Hi Hui,


I downloaded one file, yours has something in background in excel age chart though.It is a column chart over some other chart.


Many thanks

Guity
 
Guity

Which part of the "excel age chart" are you referring too?

The Excel Age charts I posted are all simple charts without anything fancy going on except the use of named ranges for some of the ranges


Ha...


My chart has a Black Background


Chandoo's chart (the pastel coloured charts) is a Chart which is in front of 4 Text Boxes

This page has been locked so that people can't move the objects

If you unlock the page you can shift everything around and see what he has done
 
Back
Top