Tag archive for How-To Tutorials - page 3

How to Find Your Custom Color Codes with a Style Guide (and Decode the Jargon)

How to Find Your Custom Color Codes with a Style Guide (and Decode the Jargon)

“Ann, which colors should I use in my graphs?” You should start with your organization’s existing color palette. Consultants, I suggest using your client’s palette, not your own. Show that you’ve gone the extra mile in customizing your work especially for them. This is one…

Continue reading →

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 →

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