How can I remove select data points from a chart/graph?

[Joel Fair]

Hi,

I would like duplicate a chart and remove some data points to make a cleaner, more presentable version of my original chart. I would like to do this while keeping the original chart and all its data points intact. This way I can see both the refined version and the original version, side-by-side, for a more in-depth analysis of the data, if needed. I realize I could hide certain rows to temporarily hide the associated data points in my table but, of course, this would affect the original chart too. Is it possible to select non-adjacent data arrays for charts so that I can present the refined version accordingly? Or is there a method for hiding data points in the "format chart" menu?

I've uploaded an example worksheet to help explain:
https://dl.dropboxusercontent.com/u...ints in a chart series - January 8, 2014.xlsx

Thanks,

Joel
(Using Excel for Mac 2011)

 

[Steve=True]

Hi Joel,

Does this tutorial and video help?

How-to Only Show Selected Data Points in an Excel Chart | Excel Dashboard Templates


Let me know.

Steve=True