Home

Excel

Monthwise Pie Chart

VBA

Listbox Option Button

Color of Points

Charts with Check Boxes

Classification Of Charts

Histogram Chart

Excel- Charts Introduction

Logarthemic Axis

Types of Charts

Creation of Chart

Dropdown Range Chart

ThermoMeter Chart

Dynamic Chart Creation

Combination Chart

If Function - Dropdown

Chart Data H Lookup

Add Vertical Line

Update in Word Doc

Format Axis Not Required

Listbox-Optionbutton

Conditonal Formatting

Chart With Tabluar Data

Scroll Bar Chart

Option Button Chart

From Top To Bottom

Matching Text TopToBottom

Hidden or Empty Cells

SpeedoMeter Chart

Offset - Column Wise

Pie Chart Month wise

Vary Chart Bar Color

Drop Dwon Chart: IF Function

Through IF function we can restrict the data set
Based on satiation of condition we can change the data, which we use in chart

Steps To Follow

Select J16 cell and create dropdown, for SALES & VALUES
Select C15 cell and update the formula as mentioned below:

=IF($J$16="SALES",$C3,$D3)

Explanation of this Formula: If data in J16 is SALES then copy the C3 value, else copy D3 value

Same formula drag into D15 cell also

Drag the formula from C15 to C23 till the last cell being copied

Drag the formula from D15 to D23 till the last cell being copied

Update below mentioned formulas while selecting data for chart:

='IF CONDITION - drop down'!$C$15:$C$23
='IF CONDITION - drop down'!$D$15:$D$23