Excel
VBA
Excel- Charts Introduction
Types of Charts
Explain the procedure to create chart with Drop down?
Create DROP DOWN by using Data Validation
Use IF function to retrive data for 2012
Use IF function to retrive data for 2013
Use IF function to retrive data for 2014
Select required chart
Here i am selecting LINE chart
From CHART TOOLS - - Click on SELECT DATA
From SELECT DATA SOURCE dialogue box click on ADD
Now add 2012 data
Now add 2013 data
Now add 2014 data
Add data for Horizontal Axis
Final Output
Hi Welcome to VBA Tutorial.
Thanks,
Pavan Kumar Gundlapalli