How to fix marker colors so that each series is a different color? Powerpoint line graph linked to Excel.

Question

I am working in Powerpoint and for the most part, the linked graphs are behaving fine. However, there is one that just started to act strangely. It is a line graph, consisting of two series. On Excel, each series has their own line color and marker shape and color. When I paste it into Powerpoint, the line and marker colors need to be adjusted because Powerpoint changes them. Not sure why, but it isn't a big deal. That is until today. I had to modify the data for the line graph and now the markers are the same color and shape. When I try to put them back the way I want them to be, all of the marker shapes and colors change, not just the series that was changed. The series aren't linked. They are two distinct series. They are different colors and shapes in Excel, but not in Powerpoint. I've tried to modify one series and then the other, but no matter what, they end up being the same color and shape.

This has only happened with one of my line graphs. The other plots are just fine. Any thoughts on how to get the markers to not become the same color and shape? I would rather not just paste a picture of the Excel graph because it becomes all blurry. To keep the detail, I paste the entire graph and it is linked to the Excel file. And it has only happened with one of the graphs. I modified a bunch and they are all fine.

Answer 1

Dear @NotForYou,

Welcome to Microsoft Q&A. 

Thank you for the detailed explanation. From what you described, this isn’t about Excel being “blurry” or the chart not being linked; it’s that marker formatting that should be per-series is suddenly behaving as if the two series are “linked” together, so changing one series’ marker style also changes the other.

Could you tell me if when you click a marker before formatting, do you see that you’re selecting the whole series (all markers highlight), or are you accidentally selecting a single data point or the entire chart/plot area?

Marker formatting is expected to be per-series. However, there are known situations where formatting can behave as if multiple series are tied together. One reported workaround is saving, closing, and reopening the file, after reopen, the “linked formatting” can stop and you can edit series independently again.

If the chart keeps losing or normalizing formatting after updates, a practical stabilization method is to save the correctly formatted chart as a Chart Template and then apply that template back onto the problematic chart.

For linked/embedded charts, PowerPoint also supports updating/editing the data via Chart Design > Edit Data (either in PowerPoint or in Excel), which can help ensure the chart refresh completes cleanly.

You can do the following:

Step 1: Break the “formatting linkage” (simple reset)

• Save the PowerPoint file and close PowerPoint completely.

Reopen the PowerPoint and let it refresh the linked chart.

This is often enough to stop the “one series changes the other” behavior.

Step 2: Reapply markers correctly (make sure you format the series)

Click the chart once > Click one marker on the series you want to change.

Right-click > Format Data Series.

In the Format pane, go to Marker > Marker Options > choose Built-in, then select the Type (shape) and Size you want.

Still under Marker, set Marker Fill and Marker Line to the color you want for that series.

Repeat for the second series.

Step 3: If it keeps reverting after data changes, use a Chart Template (best for stability)

If this is one of the standard chart types (column, bar, line, pie, etc.), then save the chart that has your preferred formatting as a Chart Template (right-click on chart, choose Save as Template). Then select the other chart and choose Chart Design>Change Chart Type, select Template and choose the template you saved to apply its formatting.

Step 4: Ensure the data refresh is clean

If the problem started right after changing data, try updating through PowerPoint’s supported flow: Select the chart > Chart Design > Edit Data > either Edit Data (in PowerPoint) or Edit Data in Excel, then save.

Please understand that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.  

I hope this information helps point you in the right direction. If you run into any issues while trying the steps, or if something still doesn’t feel quite right, please don’t hesitate to reach out again. I’ll do my best to support you however I can.  

Looking forward to hearing back from you with any updates or additional details. 

Warm regards, 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.   

Answer 2

It sounds like you're experiencing an issue with how PowerPoint handles the formatting of linked Excel graphs. Here are some steps you can try to resolve the marker color and shape issue:

1. Check Excel Formatting: Ensure that the colors and shapes of the markers in Excel are set correctly. Sometimes, reapplying the formatting in Excel can help.
2. Update Links: After making changes in Excel, ensure that you update the links in PowerPoint. You can do this by selecting the chart in PowerPoint, right-clicking, and choosing "Update Link" to refresh the data.
3. Reinsert the Chart: If the issue persists, try removing the linked chart from PowerPoint and reinserting it. This can sometimes reset any formatting issues.
4. Use Different Chart Types: If the problem continues, consider using a different chart type temporarily in Excel, then switch back to the line graph. This can sometimes reset the formatting.
5. Check for PowerPoint Updates: Ensure that your PowerPoint is up to date, as updates can fix bugs related to chart formatting.
6. Copy as Picture: As a last resort, if you cannot resolve the issue, consider copying the chart as a picture from Excel and pasting it into PowerPoint. While this may lose some detail, it can be a workaround if the formatting is critical.

If none of these solutions work, it may be worth checking if there are any known issues with your specific version of PowerPoint or reaching out to Microsoft support for further assistance.