why is excel freezing up when i want to graph

However, scatter charts are used specifically to show how one variable affects another which is called as correlation. Scatter charts are similar to line graphs, because they are useful for showing change in variables over time. There are six area charts which are area, stacked area, 100% stacked area, 3-D area, 3-D stacked area, and 3-D 100% stacked area. However, Area charts also show the area under the curve to visualize the product of both variables on x and y axis. Subtypes of bar chart Area ChartsĪre charts also show changes in values over time, like line charts. You can often use bar charts interchangeably with column charts, although some prefer column charts when working with negative values because it is easier to visualize negatives vertically, on a y-axis. Sub-types of pie chart Bar Chartsīar Charts are basically horizontal versions of column charts. There are five pie chart types which are pie, pie of pie (this breaks out one piece of the pie into another pie to show its sub-category proportions), bar of pie, 3-D pie, and doughnut. Each value is represented as a piece of the pie so you can identify the proportions. Pie Charts are made for showing information of various categories of full whole of 100%. Line Charts sub-types in Excel Pie Charts You can find these types by going to “Insert” ribbon, then clicking “Recommended Charts” and then under “All Charts” tab. These are:Īlso, all of these types have further sub-types. Microsoft Excel 20 has 14 types of charts or graphs. Therefore, learning what kind of graphs are available is necessary to learn how to make a graph in excel.

However, it is best to choose what kind of graph or chart will suit to your needs the best. Microsoft Excel has tons of types of charts and graphs and while all of them can be used to visualize any kind of data.

Why is excel freezing up when i want to graph