Excel Charts

How to Insert A Chart with Data lists in Different Range in Excel

We can create a chart by quick analysis easily if data source in chart horizontal and axis label is listed in the contiguous range. But the data source is listed in different ranges, the chart created by quick analysis cannot show data properly as we expect. So this article will show you the way to… read more »

How to Delete All Charts in Excel

If we inserted a large number of charts and want to delete all of them quickly how can we do? It will spend a lot of time if we delete them one by one in excel. So we need a quick way to delete them all conveniently. This article will provide you some methods to… read more »

How to Create Combination Charts in Excel

This post will guide you how to create combination chart and adding secondary axis in Excel.  How do I create a combination chart so that you can deliver a visual representation for multiple data source. Create Combination Charts Assuming that you have two data sources in your current worksheet, and you want to create a… read more »

How to Smooth the Angles of Line Chart in Excel

This post will guide you how to smooth the angles of line chart in your current worksheet. How do I make a smooth line chart based on your data in Excel 2013/2016. Smooth the Angles of Line Chart When you created a line chart based on your data in Excel, the angles of line chart… read more »

How to Copy Chart Format to Another Chart in Excel

This post will guide you how to copy formatting from one chart to another chart in Excel. How do I copy chart formatting to anther chart in Excel 2013/2016. Copy Chart Formatting with Paste Special Copy Chart Formatting with Short keys Copy Chart Formatting with Creating A Template Assuming that you have a chart in… read more »

How to Reverse Axis Order in Excel Chart

This post will guide you how to reverse the order of a chart Axis in your current worksheet in Excel 2013/2016. Assuming that you have created a column chart based on your data in your worksheet, and you may want to reverse the Axis order in this chart. How to do it. And his post… read more »

How to Create a Stock Chart (Open-High-Low-Close) in Excel

This post will guide you how to create a stock chart to present your stock’s data in an easy to read manner in your current worksheet in Excel. How do I create a High-Low-Close Stock market chart based on your stock data in Excel 2013/2016. Create High-Low-Close Stock Chart If you want to create a… read more »

How to Create a Chart with Two-level Axis labels in Excel

This post will guide you how to create a column chart with two-level Axis labels based on your original data in Excel. How do I create a Two-level X axis labels in your Chart with Pivot table in Excel 2013/2016. Create a Chart with Two-Level Axis Label Create a Chart with Two-Level Axis Label Based… read more »

How to Change Axis to Percentage in Excel

This post will guide you how to format excel chart axis to percentage in Excel. How do I change the Axis of Chart to percentage in Excel 2013/2016. How to add percentage sing to number on vertical axis bar in your current Chart in Excel. When you create a chart in your worksheet based on… read more »

Sidebar