Unaffiliated and back on new, improved hosting
May 12, 2024, 12:03:44 PM
Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Tekforums.net
- The
improved
home of Tekforums!
News:
Home
Help
Search
Login
Register
Tekforums
»
Chat
»
Entertainment & Technology
(Moderator:
Mardoni
) »
Excel chart question
« previous
next »
Print
Pages: [
1
]
Author
Topic: Excel chart question (Read 560 times)
zpyder
Posts: 6,946
Hero Member
Excel chart question
on:
September 20, 2010, 09:37:21 AM
Maybe a numpty question...but is it possible (and how?) to produce a scatter chart with a single data series, but with different symbols based on another series?
So say I have a dataset of average heights of people, I have also recorded their gender and age. I want to plot their height against their age as a scatter plot, but have pink symbols for the females and blue symbols for the males.
Proper stats programs make this pretty easy from memory (its been a while) but I want to produce a few dozen charts quickly and easily to just get an initial overview of trends, for some reason I think its possible but Im getting no where with what Im trying!
Logged
zpyder
Posts: 6,946
Hero Member
Re:Excel chart question
Reply #1 on:
September 20, 2010, 09:44:09 AM
heh already solved it, typical.
Just used a different data series for the different symbols. I was getting confused I think as in the stats programs (Surfer, and SPSS(I think)) you just say what you want X and Y to be, and then theres another box which you select for symbols, job done.
Logged
Print
Pages: [
1
]
« previous
next »
0 Members and 1 Guest are viewing this topic.
Tekforums
»
Chat
»
Entertainment & Technology
(Moderator:
Mardoni
) »
Excel chart question