Excel Charts

This post will guide you how to show or hide chart Axis in your current worksheet in Excel 2013/2016. How do I show or hide Axes or 3-D chart Axes, Horizontal Axis, Vertical Axis or secondary Vertical Axis in your chart in Excel. Normally, Once you create a newly chart based on your data in… read more »

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 »

This post will guide you how to add arrows to the existing Colum chart in Excel. How do I make arrow chart in Excel. Add Arrows to Column Chart When you create a column chart in your worksheet, the column bars are shown in the column chart, and if you want to change the current… read more »

This post will guide you how to change gap width for an existing bar chart in Excel. How do I change the width of charts columns in Excel. Change Gap Width in Bar Chart When you created a bar chart based on data in your worksheet, it will have gaps between their bars by default…. read more »

This post will guide you how to add axis title to a chart in Excel 2013/2016. How do I add horizontal axis title or labels to chart in Excel. By default, when you create a new chart in your worksheet based on some data, and it will display a chart title automatically and do not… read more »

This post will guide you how to add secondary Axis to an existing Pivot Chart in your worksheet in Excel 2013/2016. How do I add a secondary axis to a chart in Excel. Add Secondary Axis to Pivot Chart Assuming that you have a list of data in range A1:C5, and you want to create… read more »

This post will guide you how to create a Pareto chart in Excel 2013/2016. How do I create a Pareto Chart with Excel 2016. What is Pareto Chart Create a Pareto Chart What is Pareto Chart? A Pareto chart, named after Vilfredo Pareto, is a type of chart that contains both bars and a line… read more »

This post will guide you how to create a radar chart in your worksheet in Excel. How do I create a spider chart in Excel. Create Radar Chart Assuming that you have a list of data in range A1:C5, and you want to create a radar chart based on those data. How to achieve it…. read more »

This post will guide you how to create a speedometer chart based on data in Excel. How do I create a gauge chart in Excel 2013/2016. Create Speedometer Chart Video: Create Speedometer Chart Create Speedometer Chart Assuming that you have a list of data in range A1:B4, and you want to create a speedometer chart… read more »

This post will guide you how to create bubble chart in Excel. How do I present your data in a bubble chart in Excel. Create Bubble Chart Video: Create Bubble Chart A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles, and an additional dimension of… read more »