IF statement, or better options?

[schaelc]

Question: I have a summary sheet in my workbook which references pivot tables within the workbook and defined lists to choose from for certain team results. Since doing budget updates I want to toggle a defined list and have my budget comparison summary and graphs to flip over to the update. Would the best option be to create an IF statement referencing the budget update list to grab from a specific pivot table?

Hopefully that makes sense?

Thanks!

 

[stilesbn]

I'm a little uncertain of what your are trying to do, but I've found that if statements can be useful creating a toggle to switch back and forth between two sets of data. Say you have data in B2:B10 and C2:C10. In A2:A10 you want to display one or the other and graph it.

Make a graph that references A2:A10 and then put in the following formula in A2.

=IF($A$1=1,B2,C2)

Then drag that down to A10 and if you change A1 to "0" or anything else besides "1" then it will display the values in column C.

Not sure if this is what you're going for maybe more details would help?