Different Data Markers in a Single Excel Chart

Posted on 2012-09-13
Last Modified: 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.
Question by:sxlowry
    LVL 43

    Accepted Solution

    Maybe something like this?

    Author Closing Comment

    I like the technique.  Thanks for the help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now