If you have a Mac / Apple keyboard, the technique is the same. " I have a Mac / Macbook / Apple computer "
Drag Sales to Columns, Sub-Category to Rows and Segment to Colour, like so.
Here’s how to do it in Superstore, but the method will generalise to your own data set: I recently used this technique to good effect in a real-life business scenario, so it may be useful to you too. It’s possible to show a year-on-year trend within a table calculation.Īs an example, I’m going to use Superstore to create a graph showing how different business segments contribute to total sales, and how each segment is doing relative to last year.