Social Icons

--Making BI accessible
twitterfacebookgoogle pluslinkedinrss feedemail

Pages

Saturday, May 5, 2012

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

    




No comments:

Post a Comment