I'm trying to build a spreadsheet which charts annual snowfall of a particular ski resort and displays a graph showing the x values as days of the month (spanning a 6 month season), and the Y values as inches.
Problem I'm having is because the days of the month repeat (1-30, 1-31, 1-29, etc) excel wants to stack the graphs instead of create one long trendline which spans the whole 6 month season.
I want the x value data to show up as the day of the month but the only way I can create a single continuous line is to make the x values not repeat (IE 1-30, 31-60, 61-90, etc). I also want to be able to be able to correlate the series of days with the name of the month, something like:
1-30 1-31 1-31
Nov. Dec. Jan.
I feel like I need separate "dummy" x values; say 1-180 (in order to create the uninterrupted line) but have it reference and display the desired values of 1-30,1-31,1-31.
I don't know if this is correct or perhaps I'm going about this all wrong.
Which is why come seeking assistance
Hope what I described is not confusing...
Problem I'm having is because the days of the month repeat (1-30, 1-31, 1-29, etc) excel wants to stack the graphs instead of create one long trendline which spans the whole 6 month season.
I want the x value data to show up as the day of the month but the only way I can create a single continuous line is to make the x values not repeat (IE 1-30, 31-60, 61-90, etc). I also want to be able to be able to correlate the series of days with the name of the month, something like:
1-30 1-31 1-31
Nov. Dec. Jan.
I feel like I need separate "dummy" x values; say 1-180 (in order to create the uninterrupted line) but have it reference and display the desired values of 1-30,1-31,1-31.
I don't know if this is correct or perhaps I'm going about this all wrong.
Which is why come seeking assistance
Hope what I described is not confusing...