This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I know the data purists hate smoothed lines on an Excel chart, however...
I have a pivot chart (obviously connected to a pivot table) and am using a slicer to change the content. But... When selecting multiple values via my slicer, not all series in the chart are set to a smoothed line.
I have had all series (13 in total) on the chart and manually set them all to smoothed lines. When I select say 5 slicer values, all 5 series are no longer smoothed lines.
How can I enforce that regardless of how many series or what combination are selected that they are always displayed as a smoothed line?
Hope that makes sense!
I'm not great with VBA so if there is a non-VBA way around this, I would be grateful!
Cheers
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Then, while I didn't have that experience, I would suggest creating a graph with as many series as you might have and formatting them all to smoothed line. Then save that as a template.
--
Regards,
Tom Ogilvy
Hello,
I had the same problem and your reply helped me, thank you. But I had to smooth so many lines so I found a way to edit the template directly. Attached is a picture describing how to.
Regards!
Fred.
When you create your graph/chart it is created with a default format. Every series you add has that default format.
When you change the graph/chart type, then the series are changed as well (if you do it for the whole graph/chart).
So creating a template creates a new set of defaults.
That would be the point of a template.
So just to be sure I wasn't steering you wrong, I greated a simple scatter plot (one series) and changed it to smoothed line and then saved it as a chart template. I then deleted the chart and created a new one and chose my custom template and the series was displayed as smoothed. I added more data to the chart and each new series showed as smoothed. I created the template as using a normal chart. So it appeared to work as I assumed it would.
I think the concept is sound and it is simple enough to create that you would not lose much time in trying it. If it works, it should solve you problem.
> I'm presuming that the template takes it's defaults from the existing graph that the template is created from.
I think not. I think the defaults are changed where different from the original template.
--
Regards,
Tom Ogilvy
Thanks Tom.
I don't think however this would work as how would the template know that I want all series as a smoothed line? I'm presuming that the template takes it's defaults from the existing graph that the template is created from. As I can't get it to work in the existing graph, I don't see how the template would pick up this additional knowledge.
AndyTheAnimal,
What about creating a chart template with your custom set up and then change your pivot table chart type to your custom template:
1.
Click the chart that you want to save as a template.
2.
On the Design tab, in the Type group, click Save as Template.
3.
In the File name box, type a name for the template.
Tip Unless you specify a different folder, the template file (.crtx) will be saved in the Charts folder, and the template becomes available under Templates in both the Insert Chart dialog box (Insert tab, Charts group, Dialog Box Launcher ) and the Change Chart Type dialog box (Design tab, Type group, Change Chart Type).
Note A chart template contains chart formatting and stores the colors that are in use when you save the chart as a template. When you use a chart template to create a chart in another workbook, the new chart uses the colors of the chart template — not the colors of the document theme that is currently applied to the workbook. To use the document theme colors instead of the chart template colors, right-click the chart area, and then click Reset to Match Style.