Hello everybody
I'm facing the following problem: I'd like to do a chart with a multi-level x-axis (years and months), showing the months on one level and each year once on the second level:
I'm trying to avoid pivot charts or deleting data in the table (To create the above chart, I had to merge the cells "Year"). Is it possible to adjust the intervals of the two levels differently? (for e.g. year: 12 and month: 1)
Table:
I appreciate any help!
I'm facing the following problem: I'd like to do a chart with a multi-level x-axis (years and months), showing the months on one level and each year once on the second level:
I'm trying to avoid pivot charts or deleting data in the table (To create the above chart, I had to merge the cells "Year"). Is it possible to adjust the intervals of the two levels differently? (for e.g. year: 12 and month: 1)
Table:
Year | Month | Precipitation |
2006 | 1 | 24.9 |
2006 | 2 | 44.2 |
2006 | 3 | 12.4 |
… | ||
2010 | 12 | 38.9 |
I appreciate any help!