Sample-chart.xlsx

<div>
I like the technique. &nbsp;Thanks for the help.
</div>


I like the technique.  Thanks for the help.

<div>
<div class="content wysiwyg-content">
I have manufacturing data that is produced in short campaigns throughout the year. &nbsp;(Example: &nbsp;First campaign = first 25 data points, 2nd campaign = next 40 data points, 3rd campaign = next 15 data points, last campaign = last 30 data points.) &nbsp;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. &nbsp;<br />
<br />
Any alternative suggestion for visually segregating this data on the chart would be appreciated.
</div>
</div>


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.

Different Data Markers in a Single Excel Chart

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.