Chart Series
 

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


--
Rabangus
------------------------------------------------------------------------
Rabangus's Profile: http://www.excelforum.com/member.php...o&userid=28905
View this thread: http://www.excelforum.com/showthread...hreadid=497122

Chart Series
 

You could have the dates in col A and this formula in col B
=IF(A4<"",SUMPRODUCT((A4:A100=A4)*1),"")
copied down
then filteradvanced filteruse col A for unique itemsfiltergraph on that

--
Don Guillett
SalesAid Software

"Rabangus" wrote in
message ...

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


--
Rabangus
------------------------------------------------------------------------
Rabangus's Profile:
http://www.excelforum.com/member.php...o&userid=28905
View this thread: http://www.excelforum.com/showthread...hreadid=497122

Chart Series
 

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

In article ,
says...

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


--
Rabangus
------------------------------------------------------------------------
Rabangus's Profile: http://www.excelforum.com/member.php...o&userid=28905
View this thread: http://www.excelforum.com/showthread...hreadid=497122