#24 hr time excel x axis data switch how to

The chart is better, but I’d like to compare one season’s production to another, or compare the 2 years, so I’ll try a Stacked Column chart instead. This makes the meat types the categories along the x-axis, and the seasons are now series names in the legend. This chart is a bit crowded, but lets me compare the meat types within each year/season, or follow one type across all the year/seasons.įor my presentation I want to focus on the meat types, rather than the seasons, so I’ll switch the rows and columns. To start, I’ll create a Column chart, using the first 2-D Column chart type, which is a Clustered Column.

#24 hr time excel x axis data switch how to

We’ll see how to create a chart like this, but first we’ll look at the two types of charts it’s based on - clustered columns, and stacked columns. Here is an example of an Excel clustered stacked chart, based on the sample data shown above. Did production change much from 2002 to 2003? For all meat types? Are there seasonal differences in production?

How can you create a chart from annual or monthly data, and make the results easy to understand? See how to compare annual data in Excel Clustered Stacked Chart - like a clustered column chart, but with stacked columns, instead of normal ones.įor example, the table below shows meat production in the UK, per season, over 2 years, in thousands of tonnes.Īn Excel clustered stacked chart could show the fluctuations in production for each meat type.