LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default offset scatter plot points

This is for Excel 2007 charts---however I'm open to other (free)
user-friendly (ie non-tech savvy) programs

I have three groups/series of data points I would like to plot on a scatter
chart. The data are growth rates from different fish groups sampled on the
same date. My problem comes in with all the points over-lap along the X-axis
(day sampled). I would like the scatter points of each group to be offset,
like in a bar graph where there are three columns. I know I can go in a
change the value for day sampled in each group to slightly off-set the
points, but just wondering if there is another way to do this without
tinkering with the data.

Example of data (but many more replicates per day)
Group Growth DaySampled
1 1.47 7
1 0.86 14
1 1.77 21
2 1.28 7
2 0.75 14
2 2,01 21
3 0.05 7
3 0.15 14
3 0.50 21


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to bring data points to front on a scatter plot? Mkille Charts and Charting in Excel 2 April 4th 23 10:37 AM
Cursor alignment with data points on scatter plot chart is offset Bas V Charts and Charting in Excel 3 September 28th 07 07:14 PM
Connecting Points In An XY-Scatter Plot Graph Adam WK Charts and Charting in Excel 2 April 9th 06 07:05 PM
How do i show duplicate data points on a scatter plot? Mr.Man Charts and Charting in Excel 2 January 30th 06 03:00 PM
Scatter plot points x and y coordinates Milo Charts and Charting in Excel 0 November 28th 05 11:24 PM


All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"