Charts: Plotting Daily Values by Month?

[Jeffrey Lebowski]

Hi,

I have daily data that I graph with an area chart. How can I get the graph's x-axis to plot by month? So in the attached file with 3 months of data, the x-axis should only read Jan-Feb-Mar.

Is this possible? It would be really nice if the labels could be aligned with the data.


Thanks.

 

[NARAYANK991]

Hi Jeffrey ,

The Format Axis dialog has an option for selecting the Base Unit , which you can select to Months.

See your file now.

Narayan

 

[Jeffrey Lebowski]

Thanks for your time Narayan.

This is how I want the axis to look, however, the chart no longer reflects the daily changes.

Are the two mutually exclusive? I figure there has got to be some workaround so that you can still see the spikes and dips of the daily data but with a cleaner, less-busy x-axis than a day base unit.

Any ideas?

 

[NARAYANK991]

Hi Jeffrey ,

In which case you can set the Major Unit to months.

See this file.

Narayan

 

[Debraj]

or Multi Level Category Label will also work in this case..
Just you have to plot you data in two columns.

 

[Jeffrey Lebowski]

Hi everyone,

Using the method described above, this is how my chart looks:


Is there any way within the chart options to remove the ugly days area but keep the formatting of months, like the following cropped photo:


As you can see, I am gaining weight and trying to get back down close to 195. Your replies will help me accomplish this!

Thanks!