Excel Charts

In most excel worksheets we need to add charts to illustrate data clearly. And to make chart noticeable, we can fill chart background with color or insert a picture as background. If you want to know how to implement above functions, this article will introduce you the details with clear steps and screenshots. Follow all… read more »

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 »

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 »

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 »

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 »

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 »

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 »

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 »