Tag archive for How-To Tutorials - page 3

How to Sort Your Bar Charts

How to Sort Your Bar Charts

“Ann, my bar chart is upside down! Help!” You read my prior post about using horizontal bar charts for nominal variables like favorite fruits. My toddler is eating two! bananas a day so bananas are the winner in this fictional fruit contest. Our original table…

Continue reading →

How to Rotate Horizontal Bar Charts into Vertical Column Charts (and Vice Versa)

How to Rotate Horizontal Bar Charts into Vertical Column Charts (and Vice Versa)

“Ann, I read your latest post, and I accidentally made a horizontal bar chart when it should’ve been a vertical bar chart! Am I going to have to delete my graph and start from scratch?”   No way. Don’t delete a thing. That would be a huge…

Continue reading →

Save Time and Energy with Pivot Tables

Save Time and Energy with Pivot Tables

Pivot tables are the fastest, easiest way to make sense of your data, and they’re easier than you think. In this post, I’ll show you how to insert a pivot table and then drag and drop variables to find patterns in your spreadsheet. Step 1:…

Continue reading →

How to Adjust Your Column Chart’s Spacing in Excel

How to Adjust Your Column Chart’s Spacing in Excel

In my prior post, I sketched a few options for a performing arts organization’s fictional ticket sales data:   I intentionally separated the year-by-year bars from the total bar with a little extra space. I don’t want all the bars mushed together. Easy to sketch…

Continue reading →

How to Place Labels Directly Through Your Line Graph

How to Place Labels Directly Through Your Line Graph

I recently discussed four options for labeling line graphs. A personal favorite is to place the labels directly on top of the data points, like this: There’s been a lot of interest in this labeling technique, so here’s your step-by-step tutorial!   First, set up…

Continue reading →

Page 3 of 6 1 2 3 4 5 ... Last →