Tag Archives: line chart

How to create an Excel bar and line chart in one

I have a habit of creating charts in Excel that include both a bar chart and line chart together. They mystify people as there is no option in Excel do do such a thing. Oh, but indeed there is. Follow along my dear friends and I’ll show you.

First of all, create a bar chart as you normally would. A column for labels, a column for the first set of numbers, and a column for the second set of numbers.Bar Chart

Now the tricky part.

Click inside the chart on one set of data. You’ll see here that I clicked on the blue bars. All the blue bars have the little circles on the corners to indicate that I have indeed selected all of them.

How to create a bar and line chartNow, in the top excel menu, click the option that let’s you choose the design of your charts. In this case, it’s simply called design.

At the very left of my menu, there’s now an option that says change chart type. Click!

This opens up all the chart types and I’m going to click on the line chart. Now click OK.

And you’re done! You should now have a chart with both lines and bars in it.

Bar and Line ChartThis same process will work for any number of bars or lines. You could create a chart with one set of bars and 14 lines, or 3 sets of bars and 1 line. In the end, all that matters is that the chart is readable and doesn’t misrepresent the results.

Enjoy!

 

Other posts

Advertisements

Invesco: A Firm That Wants My Business #MRX

This is why 3D charts suck. They might just kill you.

To zero or not to zero, that is the question #MRX

I have a number of favorite interview tests, and this is yet another one. Here’s the game: I draw two different charts, just like what you see here,except without the labels on the axes. One chart has a very slow rise and the other has a very steep rise. Then, I ask my poor interviewee which chart they would like to represent the raises they will receive from year to year.

Continue reading →

5.367 tips for presenting charts people will like

Jordens inre

Image via Wikipedia

Having just attended and presented at several conferences, and with one more on the list, I’ve seen more than my fair share of powerpoint presentations in the last few weeks. Some had some great slides, and, well, others I can’t say anything about because I couldn’t read them.

As a presenter, I know you have a ton of things to worry about. Is your topic interesting? Are YOU interesting? Can you fill up so much time and not flub it all up? It seems we leave building a readable presentation to the end of the list and then we never actually finish the list.

With that in mind, here are just a few tips that will result in your audience being more appreciative of your presentation. And they’re quick so try them out!

  1. If one line or bar represents the “right” number, colour it green. And vice versa, if one line or bar represents the “wrong” number, colour it red. People are primed to interpret green as go and red as stop so help them understand your data more easily.
  2. If you’re using a line chart, make the lines really thick, thick as in 5 to 10 points. There will be people at the back of the room because there are no seats at the front (yay!). Help them like your presentation by allowing them to see the data too.
  3. Increase the font sizes to crazy big numbers everywhere. Do you need a vertical scale? Increase that font! Need a horizontal scale? Increase that font! Make it so big and fat that it looks wrong – because it will look right from the back of the room. Font sizes should be at least 20 points but go with 30 or more if you can make it work.
  4. Make the chart as big as you possibly can. Take extraneous words off the page to give more room to the chart. If the words aren’t on the page, it will give you something to say instead of read. And people will be grateful for it.
  5. For the love of God, don’t make your chart 3D! Sure, it may be pretty but 3D in presentation style is ten times worse than 3D in paper style. There’s no way your audience can pull your slide close to their face to more accurately interpret all the extra chart junk that 3D creates. Simple is good. Simple is readable.

5.367. Do not default to the default chart. Default charts are there for people who shouldn’t be using charts in the first place. You are smarter than your software so think about your audience, your purpose, the room where you’ll be presenting and create a custom chart that will work for that specific situation.

Why 5.367? Because people are more likely to believe numbers that use decimal places. Do you believe that?

Read these too

My Awesome Haiku

Trending up and down,
………Revealing both good and bad,
…………………The line chart speaks clear.

%d bloggers like this: