This technique really works with just any types of data. Play with the formulas & chart formatting to learn. Pretty simple, eh? Download the Excel Chart TemplateĬlick here to download excel chart template & workbook showing this technique. Excel shows nicely grouped axis labels on your chart. Use both year and month columns for axis label series. Process your data: Assuming your data looks like what I shown to left, just use simple formulas to make it look like the table to right.But I can tell you how to fix that axis so it looks a lot better, may be like this: Now, there is nothing much I can do about donut consumption. The year -09 and -10 repeating across bottom of axis is pure chart junk.For example, lets say you want to plot the number of donuts consumed per month in a chart, like this:Ģ things become quite obvious when you look at this chart, We make charts with date axis all the time.
0 kommentar(er)
