Conditional formatting in charts

[lisa131067]

Hi I have an excel file which my predecessor created which has lots of tables and charts in. When I type an X in a certain cell it leaves the tables and charts in place but hides/does not show the chart bars and table data in them.

I am trying to recreate this conditional formatting in a new file but can't get it to work and the data in the charts wont disappear. I have worked out how to apply conditionaly formatting so the data in the tables is blanked out but the charts will not work. Please Does anyone know how I do it?

thanks a million Lisa

 

[lisa131067]

totally stuck!

 

[lisa131067]

still stuck just need to know how to conditionally format charts/chart data so entering a value in one cell turns chart visbility on/off

 

[VoG]

We really have no way of knowing without seeing the workbook.

I suspect that VBA code may be involved. Right click the tab of a sheet containing charts and select View Code. Is there code? If so paste it in a reply to this thread.

 

[lisa131067]

Hi there

thansk for your reply. Ive checked and theres no code at all. I need to find out how you apply conditionaly formatting to graphs as that's been done in this case so the data shows/doesnt show if a condition is satisfied. does that make sense?

thanks Lisa

 

[Steve=True]

Your predecessor may have used the =NA() feature of most charts.

He probably created a chart area that looked at the data tables.

If there was a "X" then the chart area formula put this =if(a1="X",NA(),a1)

That way if there is no "X", show the data. If there is an "X", put in an NA() value which will not be plotted in the graph.

Hard to tell exactly without the file.

Steve=True
www.exceldashboardtemplates.com