
Switch the data on each axis, if necessary.

Highlight your data and click 'Insert' your desired graph.Choose one of nine graph and chart options to make.The steps you need to build a chart or graph in Excel are simple, and here’s a quick walkthrough on how to make them. Surface charts plot sets of values in the form of a three-dimensional surface. Stock charts are used to report the fluctuation of stock prices over given periods. Scatter charts show the positive or negative relationship between two variables. Radar charts compare the aggregate of multiple data series. Pie charts show values as percentages of a whole. Similar to bar charts, they illustrate trends over time. You can make more than just bar or line charts in Microsoft Excel, and when you understand the uses for each, you can draw more insightful information for your or your team’s projects.Īrea charts demonstrate the magnitude of a trend between two or more values over a given period.īar charts compare the frequency of values across different levels or variables.Ĭolumn charts display data changes or a period of time. But before diving in, we should go over the different types of charts you can create in the software. I thought I'd share a helpful video tutorial as well as some step-by-step instructions for anyone out there who cringes at the thought of organizing a spreadsheet full of data into a chart that actually, you know, means something. Use the download file to learn how that is done.However, it's no surprise that some people get a little intimidated by the prospect of poking around in Microsoft Excel. I used gradient fill technique to get two colors in the same box. The legend is almost manual. I just created a bunch of rectangles and typed the text in them. We get these beauties.Īs regular gridlines can be too grainy, I removed them and used error bar technique to draw a line from bottom to top of the stream.

Used that to make axis labels for important issue #s and hidden the line. I made these lines smooth lines and colored them in white.Īxis labels are data labels on a hidden line: To get the crisp stream effect, I have added two lines, one at bottom and one on top of the stream. Related: How to make your charts & dashboards interactive? Stream chart edges – lines with smoothing option: See below illustration to understand how they all create the illusion. The interactivity in the stream graph is done with 4 option buttons, icons, text & conditional formatting.

I used Power Query to connect to the file and add an extra column to extract mutant character names. The data for this came from Github project page ( link).

Now that you know how to make a stream appear, let me unravel the rest of this beautiful x-men appearances chart.
