Remember, your chart is tied directly to your data set-meaning any mistakes that appear there will also show up in your chart. Double-check and highlight your dataĪs always, it’s smart to take a quick look to check if there are any issues or blatant errors in your data set. We’ll use a column chart to represent the number of subscribers and a line chart to represent the open rate. We’re going to create a combination chart to understand this relationship. We want to analyze the relationship between open rate and subscriber count-basically, does open rate increase or decrease the larger our subscriber list gets? Now, we have some more data added to that: the average email open rate for each month. In our basic Excel charts article, we analyzed the growth of an email subscriber list. So, for the sake of rolling up your sleeves and getting started, we’re going to pick one slightly more advanced chart and work on creating that. With so many different chart types and the option to combine them, there’s no possible way to outline every single chart you could make in Excel.

Creating an advanced Excel chart: A case study

That could be one of the more in-depth charts we just mentioned, like a surface chart, or it could be a combination chart-where you take two different chart types (like a bar chart and a line chart, for example) to visualize a more involved data set. We consider an advanced chart to be any chart that goes beyond the basics to display even more complex data. Take a look in Excel, and you’ll quickly notice that there’s no shortage of charts available.įrom the basics (like column charts, bar charts, line charts, and pie charts) to options you may have less familiarity with (like radar charts, stock charts, and surface charts), there are seemingly endless charts you can make within Excel.

Excel data charts examples