Need help in creating Charts

[desaitejas]

Hi,


I have to different data sets viz..


Data Set 1: From April 10 - Aug 10... week wise I have some figures.

Data Set 2: From April 10 - Aug 10... week wise I have some figures.


Problem is I want to show in graph week/month wise comparison of Data set 1 to Data Set 2.


Can you please help in creating the stack graphs for the same in single chart output.


Regards,

Tejas

 

[Hui]

Desaitejas


Firstly, Welcome to the Chandoo.org Forums


Setup a Data area which will contain

a Header Row of Dates 1/4/2010, 1/5/201, 1/6/2010 etc

then setup 2 lines to retrieve the data from your two areas

You will need to use a Sumifs or Sumproduct to get the data

eg:

=Sumproduct((Date Range1>=Start of Month)*(Date Range1<=End of Month), Data Range1)

or

=Sumifs(Data range1, Date Range1, ">="Start of Month Date,Date Range1, "<="End of Month Date)


Repeat for Data Range 2


Then do a stacked Column chart with these 3 new sets of data