Excel Charts

This post will guide you how to create a graph or chart in Microsoft Excel. You will learn that how to create a simple Chart in Excel. You can learn that how to create different types of charts in Excel, or how to change the Excel Chart type, etc.

Create New Chart

If you want to create a graph or chart based on the specified data in your worksheet, you can refer to the following steps:

1# select the data range, such as: A1:D4

excel chart1

2# go to Insert Tab, Click Insert Line Chart button under Charts group.

excel chart2

3# click any one Line with Markers from the drop down list

excel chart3

4# you will see that one Excel Chart has been generated as below:

excel chart4

 Change Chart Type

There are 9 Chart types that you can choose in Excel 2013, such as, Line Chart, Pie chart, Bar chart, Column chart, Area chart, Stock chart, surface chart, radar chart and Combo chart. So your current chart type is not well-suited for your newly data, and you can easily change it to other chart type.  Just do the following steps:

1# Select the chart that you want to change the type

2# go to Design Tab, click Change Chart Type command under Type Group.

change excel chart type1

3# the Change Chart Type window will appear.

4# select one chart type that you want to change to on the left side.

change excel chart type2

Or you can directly right-click anywhere within the chart and then select Change Chart Type…. Form the drop down list. Then the Change Chart Type window will appear.

change excel chart type3

 Change Legend Position

If you want to move the legend to the right side of the chart, just refer to the following steps:

1# Select the chart

2# click the Chart Elements ( +) button on the right side of the chart, select the Legend checkbox, then select the position as Right menu.

legend change1

3# let’s see the result that the legend has been moved to the right side of the chart.

 legend change2

Display Data Labels

If you want to display data labels on a single data point, you can following the steps to add data labels:

1# Select the chart

2# click one data point that you want to display the data labels, such as, Excel data point.

display data label1

3# click the Chart Elements ( +) button on the right side of the chart, select the Data labels checkbox.

display data label2

4# let’s see the result.

 display data label3

Display Data Table

You can also display the data table in the chart or graph, do following steps:

1# Select the chart.

2# click the Chart Elements ( +) button on the right side of the chart, select the Data table checkbox.

display data table1

3# Let’s see the result.

display data table2

Switch Row/Column

If you want to move the data being charted on the X axis to the Y axis, just do the following steps to swap the data over the axis:

x
How to Highlight Every Other Row Using Conditional Formatting in Excel

1# Select the chart

2# go to Design Tab, click Switch Row/Column command under Data group.

switch row column11

3# let’s see the result.

switch row column1

 

Related Posts

How to Show or Hide Chart Axis in Excel
show or hide chart axis5

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 ...

How to Fill Chart Background or Insert Background Picture into Chart in Excel?
Fill Chart Background or Insert 11

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 ...

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

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 ...

How to Delete All Charts in Excel
Delete All Charts 9

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 ...

How to Create Combination Charts in Excel
create combination charts7

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 ...

How to Smooth the Angles of Line Chart in Excel
smooth angles of line chart3

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 ...

How to Copy Chart Format to Another Chart in Excel
copy chart format to another chart9

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 ...

How to Reverse Axis Order in Excel Chart
reverse axis orader3

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 ...

How to Create a Stock Chart (Open-High-Low-Close) in Excel
create stock chart 4

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 ...

How to Create a Chart with Two-level Axis labels in Excel
create chart with two level axis14

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. ...

Sidebar