...

MS Excel VBA

Create Charts in MS Excel

Create Charts in MS Excel

Ms Excel VBA Teach You A simple chart in Excel can say more than a sheet full of numbers. As you will see, creating
charts are extremely easy.

1: Select the range A1:D7

2. On the Insert tab

In the Charts group, Click the Line symbol.

3. Click Line with Markers!

4. Results_:

Note: Enter a title by clicking on the Chart Title.
For example, a Wildlife Population.

Change Chart Type

You can easily change to a different type of chart at any time when you want!

1. Select the chart.
2. On the Chart Design tab, in the Type Of  group, click Change Chart Type

3. On the left side, click Column.

4. Hit OK.
5. Here is the Result

Switch Row/ Column

Still, execute the following way, If you want to display the creatures( rather than the months) on the vertical axis.

1. Select the chart.
2. On the Chart Design tab, in the Data group, click Switch Row/Column.

3. Result:

Legend Position

To move the legend to the right side of the chartexecute the following route.

1. choose the chart.
2. Click the push button on the exact side of the chartChoose the arrow next to Legend and click Right.

3. Result:

Data Markers

You can use data markers to concentrate your albums‘ absorption on a single data series or data point.

1. Choose the chart.
2. commune a green bar to select the Jun data series.
3. Hold down CTRL and apply your arrow keys to select the population of Dolphins in June( bitsy green bar).
4. Click the push button on the exact side of the chart and click the check box next to Data Labels.

Here is the Result:

 

Learn more about the Charts with Us!

 

Learn Complete Microsoft Excel Tutorial

 

Leave a Comment

Your email address will not be published. Required fields are marked *


Scroll to Top