month day data
1 1 .234
1 2 .246
1 3 .258
1 4 .267
est.

I have three columns, one with the month, the second is the day of that month and third is the data of that day. so I have a lot of data to graph.
And I can not use the "scatter chart" type. It must be a line graph.
So I need to find out how to graph in "Months only". every time I graph it I get multiples of mouths or dates,
like JFMAMJJASONDJFMAMJJASONDJFMAMJJASOND!
I just want This: J F M A M J J A S O N D one time
How Do I achieve this?

Hi Windseaker,

See the attached. I simply inserted a month name every 30 rows, starting at row 15, and used that for the horizontal axis labels.

Attached Files

Chart.xlsx (24.7 KB, 11 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]