Hidden cells in graph

Dec 1, 2010 at 2:49 PM

Hello,

I'm sorry for my poor english, but i'm French.

It's possible to have hidden cells in graph ?

In French :

Est-il possible d'avoir des cellus cachées dans un graphe ?

Si oui, comment ?

 

 

Best Regards.

Coordinator
Dec 2, 2010 at 2:55 PM

Hi,

There is no property for changing "the show data in hidden..." checkbox by code, but I'll add that to my TODO list.

The easiest way to do this is to use a template with a graph that has the appropriate settings.

I had a quick look at it and if you dont want to use a template, here is a "hack" to remove the plotVisOnly tag from the ChartXml to "flip" the checkbox... 

XmlNamespaceManager ns=new XmlNamespaceManager(new NameTable());
ns.AddNamespace("c","http://schemas.openxmlformats.org/drawingml/2006/chart");
var element = chart.ChartXml.SelectSingleNode("//c:plotVisOnly", ns);
if (element!=null) element.ParentNode.RemoveChild(element);

Replace the chart variable with your chart.
Jan
Dec 3, 2010 at 9:52 AM

Thanks.

I test this code.

Fabrice.

Dec 3, 2010 at 10:14 AM

It's OK

Thanks.

Fabrice.