Use the original data as a source for a Pivot Table (and corresponding
PivotChart).

--
Regards,

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

In article , "=?
Utf-8?B?QWlzaGEgS2hhbg==?=" <Aisha
says...
I am trying to create a simple line graph with months labelled in the X axis
and the frequency of an event noted in the Y axis? How do I do this? I have
turned on the date feature and all of the tick marks are labelled J for
January.