Chart Series

  • Thread starter Thread starter Rabangus
  • Start date Start date
R

Rabangus

Hi All,

I consider myself to be pretty profficient when it comes to Excel and
VBA, but charts are pretty much a mystery to me.

I have a spreadsheet where vba code populates a date column when other
data is entered. Therefore all the dates are in exactly the same
format.

What I want to do is create a bar chart with the dates as the x axis
and the number of times that date appears as the y axis values.

For example, with the data below (yes, there can be blank cells) I
would like a chart that has 28/12/2005, 29/12/2005 and 30/12/2005 as
the x axis, and 5, 2 and 2 as the valies for the y axis.

29/12/2005
29/12/2005

28/12/2005
28/12/2005

28/12/2005

28/12/2005
28/12/2005

30/12/2005
30/12/2005

Is this possible?

Cheers
Rowan
 
You could have the dates in col A and this formula in col B
=IF(A4<>"",SUMPRODUCT((A4:A100=A4)*1),"")
copied down
then filter>advanced filter>use col A for unique items>filter>graph on that
 
Create a PivotTable with an accompanying PivotChart.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top