Advanced Excel Chart Formatting – MS Excel Charting Tutorial Part 5

Excel Charts

 

In previous posts, we learnt about various chart types in Excel, how to select a chart based on message that we want to convey graphically and finally, how to create an Excel Chart. We also learnt about basic formatting of Excel Charts. In this post, we will learn about more advanced formatting of Excel Charts.

Advanced Excel Chart Formatting

We will be covering below topics.

How to Use Chart as Hyperlink

This feature is particularly useful in presentations and in excel dashboards. The trick is to convert your chart to an image as hyperlinks can only be done to an image.

Step 1: Select your chart and copy it (CTRL+C)

Step 2: Click on any location where you want to paste your chart and select “Paste Special”.

Step 3: Clicking the “Paste Special” option will open a window. Select “Picture JPEG”

Step 4: The chart is converted to a “JPEG image”. Now we can add hyperlink to this image.

Creating Two graphs on the Same Chart

We can create two different types of graphs on the same chart. This is generally done when we want to establish the relationship between two sets of values. Let us consider our college data base example.

Now let us suppose that we want to show the relationship between the attendance of a student and his/her marks with the help of two separate graphs. This is how we can do it:

Step 1: Select the data and create a “Column Chart”.

Step 2: Now let us suppose that we want a “Line Chart” for the attendance. We can create a line chart for attendance by clicking on the chart and selecting the red bard which depict “Student attendance”. This will open a list. In the list select the option “Change Series Chart Type”.

Step 3: Clicking on “Change Series Chart Type” option will open a dialog box which will contain all the chart types. We can select the “Line Chart” option and our “Bar Chart” will be converted to a “Line Chart”!

Changing the Scale of X and Y Axis

If you want to change the scale of X and Y axis follow these simple steps:

Step 1: Select your scale values and press right click. Click on “Format Axis” in the list. A window will open. This window will allow you to change the scale.

This was the last post of series on MS Excel Charts Tutorial. We hope that you liked the content and feel little easy with Excel Charts now. Please feel free to leave your suggestions, queries, feedback in the comments section below.

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">