• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Charting

A

ahhhmed

Member
Hello,
How can we conditionally choose data for charting? I mean for a certain value, a chart will be made for a range of cells, for another value the chart will be for another range of cells, but appears in place of the first chart. I hope I am clear.
 
Many different ways of doing this. The simplest would be via formulas. Let's say your two choices for data are in col B and C. Your formula cells would be:
=IF(TriggerCell = "Option1",B2,C2)

You would then create the chart based on the cells with formulas. As the TriggerCell changes, the formulas get updated, and the chart changes.
 
You must log in or register to reply here.
Back
Top