You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Lots and lots of you want to brush up on your Excel skills by going beyond creating basic charts. How do we know? Because so many of you click this page. Today, we're moving it back to the top of our home page to make it easier for you to find.
Excel comes with lots of chart types, including column, line, pie, and so on. However, many of you ask how to make other kinds of charts, such as floating column charts, Gantt charts, combination charts, organization charts, flow charts, hierarchy charts, histograms, or Pareto charts.
While none of the charts above are available as predefined chart types, don't worry. There are ways to create them in Excel.
A floating column chart is great for comparing the low and high levels in a value range, represented by the bottom and top of the floating columns, as you can see in this daily blood sugar level ranges chart.
For the chart below, I create a stacked column chart from two data series on the worksheet. The first data series measures to the lowest value of each daily blood sugar range and the second data series measures the actual blood sugar level range that I want to display in the chart. Then I hide the first data series to simulate a floating effect.
For more information, see Present your data in a column chart.
I can use the same method to create a Gantt chart that displays the sequence of a few tasks I have scheduled. For this chart, I'll use a stacked bar chart that has two data series. When I hide the first data series, the chart will show floating bars, which is perfect for a Gantt chart.
For more information, see Present your data in a Gantt chart in Excel.
Combination (or combo) charts are also not available in the list of predefined chart types. When I want to emphasize different types of information in a chart, I can use two or more chart types in the same chart. I often combine a column chart with a line chart for an instant visual effect that might make the chart easier to understand. If the data of the different chart types varies a lot, I also use a second vertical axis (the one on the right in the chart below) for the second chart type. This really helps clarify the data that's shown in a combo chart.
For more information, see Present your data in a combination chart.
Organization, flow, and hierarchy charts are an entirely different animal. There's no easy way to simulate these types of charts by using predefined chart types. Instead, I need to use SmartArt graphics to create them.
For more information, see Create an organization chart.
Histogram and Pareto charts are column charts that display frequency data, but they are not available as predefined chart types either. To create them, I've used the Histogram tool of the Analysis ToolPak, an Excel add-in program that comes with Excel.
For more information, see Present your data in a histogram.
These are just a few examples that may inspire you to create that "other" chart type. I'd love to hear about any creative ways you have used to present your data in a chart type that simply isn't available in the list of chart types.
More info on Excel charts:
Combining Chart Types, Adding a Second Axis Create a chart from start to finishFree training: Take the next steps in growing your Excel skills (Lesson 2) Can't find the Chart Wizard? No worries Use sparklines to show data trendsLine or scatter chart?Format column sparkline charts using the date axis and cell merging
One of the most used charts, in real life corporate work, is the combination between a bar chart and a line chart. Also the stack column bar chart is very good for presenting data. Many users don't know how to put the totals on top of the stack column bars. Here's my article on how to do it:
This is, by far, the most viewed article of all time on my blog. This indicates me that this is one of the biggest doubt that Excel user's have on pratical life.
I like the floating column technique. It's a useful one.
I've had to do a lot of Pie in Pie Charts for my clients and I have needed to do a lot of research and testing. I've created a free tutorial if anyone finds it helpful.