Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
C#: XYScatter chart with smooth lines and no markers
I hv been working on a Office 2007 App level add-in project using VS2005,
..Net 2.0, VSTO for Office 2007 and Office 2007 Interopps. I want to draw a XYScatter chart with smooth lines nad no markers. Why, even if we set the ChartType to xlXYScatterSmoothNoMarkers you get markers? xlChart.ChartType = Microsoft.Office.Interop.Excel.XlChartType.xlXYSca tterSmoothNoMarkers; Is there any way to change XYScatter line thickness? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
C#: XYScatter chart with smooth lines and no markers
OK....I got this matter solved after trying several combinations.
We can use Chart.ChartWizard() method, where in parameters we can mention the chart type we want. Using Chart.ChartWizard() really reduces the amount of code lines to be written. Changing the thickness of the line is possible after obtaining a reference to the line in the series. Microsoft.Office.Interop.Excel.Series s = (Microsoft.Office.Interop.Excel.Series)xlChart.Ser iesCollection(1); s.Format.Line.Weight = (float)0.25; "Thilina Dampahala" wrote: I hv been working on a Office 2007 App level add-in project using VS2005, .Net 2.0, VSTO for Office 2007 and Office 2007 Interopps. I want to draw a XYScatter chart with smooth lines nad no markers. Why, even if we set the ChartType to xlXYScatterSmoothNoMarkers you get markers? xlChart.ChartType = Microsoft.Office.Interop.Excel.XlChartType.xlXYSca tterSmoothNoMarkers; Is there any way to change XYScatter line thickness? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How does Excel smooth chart data when smooth option is selected? | Charts and Charting in Excel | |||
How do print a chart with smooth lines? | Charts and Charting in Excel | |||
How do I smooth the lines around a pie chart? | Charts and Charting in Excel | |||
Smooth lines for 3-D pie charts? | Charts and Charting in Excel | |||
How do I make the lines "smooth" in my 3-d pie chart? | Charts and Charting in Excel |