Different Data Markers in a Single Excel Chart
Posted on 2012-09-13
I have manufacturing data that is produced in short campaigns throughout the year. (Example: First campaign = first 25 data points, 2nd campaign = next 40 data points, 3rd campaign = next 15 data points, last campaign = last 30 data points.) I would like to present the data for the entire year on a scatter chart, but have a different style of data marker for each campaign to make it visually easier to see where each campaign starts and stops.
Any alternative suggestion for visually segregating this data on the chart would be appreciated.