Changing the size of data point icons/markers in OWC pivot charts

[cvs]

I know this can be done in excel.

Can anyone kindly let me know if this can be done in OWC.

The data icons/markers are currently too large as we are showing four
charts on each page (scatter charts, line charts with markers etc)



Thanks


Brian

 

[Alvin Bruney [MVP]]

As far as I know, data marker size changes are not supported in OWC

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[cvs]

Thanks Alvin

I note from the existing code I have there is a part like...

<x:FormatValue>
<xataSourceIndex>-3</xataSourceIndex>
<xata>3</xata>
</x:FormatValue>
<x:Marker>
* <x:Size>1</x:Size>
<x:Symbol>Dot</x:Symbol>
</x:Marker>

I have tried changing the value 1 in the line marked * however this was
without success or any apparent change in the marker .

would you expect this to change the size of the marker.

Client is very keen to address this

Brian

As far as I know, data marker size changes are not supported in OWC

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

I know this can be done in excel.

Can anyone kindly let me know if this can be done in OWC.

The data icons/markers are currently too large as we are showing four
charts on each page (scatter charts, line charts with markers etc)



Thanks


Brian

 

[Alvin Bruney [MVP]]

have a look at this code, see if it helps
http://msdn.microsoft.com/library/d...us/owcvba11/html/ocobjChMarker_HV03083250.asp

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Thanks Alvin

I note from the existing code I have there is a part like...

<x:FormatValue>
<xataSourceIndex>-3</xataSourceIndex>
<xata>3</xata>
</x:FormatValue>
<x:Marker>
* <x:Size>1</x:Size>
<x:Symbol>Dot</x:Symbol>
</x:Marker>

I have tried changing the value 1 in the line marked * however this was
without success or any apparent change in the marker .

would you expect this to change the size of the marker.

Client is very keen to address this

Brian

As far as I know, data marker size changes are not supported in OWC

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

I know this can be done in excel.

Can anyone kindly let me know if this can be done in OWC.

The data icons/markers are currently too large as we are showing four
charts on each page (scatter charts, line charts with markers etc)



Thanks


Brian