Solved

need to show symbols in a plot

Posted on 2011-09-22
3
238 Views
Last Modified: 2012-05-12
Hi,

I need to create a scatter plot of d2H vs d18O data, as shown in columns D and E in the attached spreadsheet.  I also need to show, using symbols and/or colors, which "category" (from column A) each data point belongs to and which "site" (from column B) each data point belongs to.  Finally, I need to be able to show the ID of the point (column C).

Thanks!

TC isotopes-for-expert-exchange.xls
0
Comment
Question by:trcamp
  • 2
3 Comments
 

Author Comment

by:trcamp
ID: 36587202
Points have been increased to 250.
0
 
LVL 50

Accepted Solution

by:
teylyn earned 250 total points
ID: 36592299
Hello,

If you want different colors and different symbols, then you will need to create different series for each color and/or symbol combination. Lay out the data to support that, for example with the aid of a pivot table or by manual copy and paste.

To show the ID of the point, you can use the free XY Chart Labeler Add-in, available at
http://www.appspro.com/Utilities/ChartLabeler.htm

This will be some work to set up and is not necessarily trivial. The chart will need a lot of tweaking. Questions of this magnitude typically go for more points.

cheers, teylyn
0
 

Author Closing Comment

by:trcamp
ID: 36599371
Thanks Teylyn.  This got me there.  I especially appreciate the link to the data labeler, which works perfectly.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

746 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

9 Experts available now in Live!

Get 1:1 Help Now