Displaying more charts in an Excel worksheet using Indirect Function

Hey there!!

Today's task: Using a single Excel Sheet to fit more charts .Capacity Utilisation it is!



Key Concepts:

1. Indirect Function  :

Key Requirements:

• Lot of Excel Charts! for understanding the concept of conditional replacement

Charts Data Snapshot:

Charts Snapshot        :



These charts will be retrieved using Indirect function

Named Range used:

Steps for creating Dynamic Chart Switching with Radio Buttons

Note:First you will need two charts beforehand 

1. Inserting Option Buttons:

• Developer->Insert->Form Controls->Option Button
• Right click on Option Button , click on format control and input the following values

              

               Cell Link : $M$5 

       
               Named Range 'GetCharts' for conditional Chart switching

   2.  Insert a Picture from computer

   3. Click on the inserted picture

   4. After clicking,type " =GetCharts "in the formula bar    

  

   5.  After clicking enter the chart will be retrieved

Gentlemen!We have done it.Make best utilisation of available space in an excel sheet.Make it look more funky and an outlier !

Does it look like this?

Chart Views:

1.Radio Option Selected:   Graph 1

2.Option Selected:   Graph 2

Please comment with your email id for receiving the actual workbook