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.
- Types Of Charts In Excel
- Choosing The Correct Chart Type
- How To Create Excel Charts
- Basic Excel Chart Formatting
- Advanced Excel Chart Formatting
We will be covering below topics.
- How to Use Chart as Hyperlink
- Creating Two graphs on the Same Chart
- Changing the Scale of X and Y Axis
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”.
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.
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”!
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.