6 Must Know Line Chart variations for Data Analysis
Line charts in Excel are essential for trend analysis, spotting distribution and outliers. Use these 6 variations to get more out your line chart.
- Indexed Line Chart
- Sparklines
- Spaghetti Line Chart
- Smoothed Line Chart
- Forecast Line Chart
- Line Chart Combinations
Stacked Bar/Column Chart with Indicator Arrows – Advanced
Lets take last weeks Stacked Bar/Column Chart and add some high-performance steroids.
Stacked Bar and Indicator Arrow Chart – Tutorial
Learn how to develop a Stacked Bar chart with Indicator Arrow in this Tutorial
Cropped chart: when some values are too big to fit
We know that column charts are excellent for presenting information. But what if some of the columns are too tall and hijacking the rest. In a previous article, we discussed few of the approaches. Today let’s learn how to build a cropped chart (broken y-axis chart) using Excel, something like above.
Looks interesting? Read on.
Combine pie and xy scatter charts – World Polls chart revisited
Few days ago, we learned how to create a pie+donut combination chart to visualize polls around the world in 2014. It generated quite a bit of interesting discussion (47 comments so far). One of the comments was from Roberto, who along with Kris & Gábor runs The FrankensTeam an online library of advanced Excel tricks, charts and other mind-boggling spreadsheet wizardry.
I really liked Roberto’s comments on the original post and a charting solution he presented. So I asked him if he can do a guest post explaining the technique to our audience. He obliged and here we go.
Over to FrankensTeam.
Bar chart with lower & upper bounds [tutorial]
Bar & Column charts are very useful for comparison. Here is a little trick that can enhance them even more.
Lets say you are looking at sales of various products in a column chart. And you want to know how sales of a given product compare with a lower bound (last year sales) and an upper bound (competition benchmark). By adding these boundary markers, your chart instantly becomes even more meaningful.
Lets learn how to create a column chart with lower & upper bounds in this tutorial.
10 things that wowed me in Excel 2013
As you may new, the newest version of Excel is out for a while. I have been using it since last 6 months and enjoying it. Today, lets understand 10 things in 2013 that wowed me (and probably you too).