Line Chart Formatting

[Krinsom]

Hi,

I have built a line chart from a pivot table (dynamic table) and then smoothed the lines.

The matter is that everytime I update the chart, the smooth format is lost and all the lines turns to straight angles again.

How to keep the smooth line without losing its format when updating?

Cheers


Krinsom

 

[Hui]

Krimsom


I normally setup the chart as you want it and then save it as a template.

When you update the chart re-apply the template


You can automate that so that every time the Pivot table is Refreshed the chart template is re-applied using a simple macro like below

[pre]

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ApplyChartTemplate ("C:UsersIanAppDataRoamingMicrosoftTemplatesChartsTest.crtx")
End Sub

[/pre]
Change the Template Name and Location and Chart ID as appropriate