All You Need to Know About

Excel Chart Tutorials

Learn how to make your data talk with beautiful looking Charts.

This section shows how much you can do in making charts in Excel. You will be surprised how easy it is to visualize your data using Excel Charts! Here are the top things you can do with making charts in Excel:

Top 10 Tutorials

  1. Add an Interactive Vertical Column in Your Excel Line Chart– With Excel Charts, it is very easy to create a Vertical Column in your Line Chart and make it interactive with a Scroll Bar!The reason why I do this, is to use the vertical column to highlight a specific point in my Excel chart whilst I am presenting the data to my stakeholders.Read more
  2. Candlestick Chart Using Excel– Stock Data Analysis is no easy feat! Once you have a lot of historical stock data it’s hard to visualize the trend using technical analysis. Thankfully Excel has a lot of stock charts to help you with that, and one of them is the Candlestick Chart!Read more
  3. Add Trendlines to Excel Charts– With Excel Charts, it is very easy to create Trendlines for your data. Trendlines show which direction the trend of your data is going, and gives you the trajectory as well.Read more
  4. Area Chart: Highlight Chart Sections– When you are showing 12 month sales results using a Line Chart and want to highlight certain values within the chart to make them stand out (like Q2 & Q3 results), then an Area Chart will be needed.Read more
  5. Overlap Graphs in Excel– Overlapping graphs in Excel is used to compare two sets of data in one graph, like Actual v Plan results. This overlay of graphs may seem like a difficult exercise but it is a very easy process.Read more
  6. Create a Box and Whisker Chart With Excel 2016– Box and Whisker Charts are one of the many new Charts available only in Excel 2016 and were originally invented by John Tukey in 1977. They show you the distribution of a data set, showing the median, quartiles, range and outliers.Read more
  7. Bubble Chart: 3 Variables On A Chart– A Bubble Chart is an extension of the XY Scatter Chart. It adds a 3rd variable to each point in the XY Scatter Chart. For example, if you have a Scatter Chart that shows the relationship between the age of a house and its proximity to the city and want to add the value of the house (the 3rd variable), then a Bubble Chart will get you there.Read more
  8. Project Milestone Chart Using Excel– Project Management is no easy feat! There are lots of moving parts, long hours and constant reporting. It requires you to keep everybody on the same page and focused on the goals and timelines. One of the key reporting tools needed is the project milestone or timeline chart. Luckily you can create a project milestone chart in Excel in just a few steps…well, 11 to be exact!Read more
  9. Clustered Bar Chart: Year over Year Comparison– If you want to compare products or businesses Year over Year and have category names which are way too long, then the Clustered Bar chart is the one for you.Read more
  10. Logarithmic Scale In An Excel Chart– You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10. What this does is it multiplies the vertical axis units by 10, so it starts at 1, 10, 100, 1000, 10000, 100000, 1000000 etc.Read more

Read More

Latest Tutorials

Want to get better at Excel?

Join Our Excel Community

Get our Free Weekly Excel lesson plans that cover the must know Excel features and tips to make you better at Excel!