ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I combine points in a scatter diagram without drawing by hand (https://www.excelbanter.com/excel-discussion-misc-queries/46438-can-i-combine-points-scatter-diagram-without-drawing-hand.html)

Anna A (Sweden)

Can I combine points in a scatter diagram without drawing by hand
 
I have made a line diagram with several series. The problem is that the
different series don't have the same X values (it's different sampling
dates), and when an X value is skipped for a serie (ex. dates 3/12, 5/12 och
9/12, where I only have Y values for the first and last date), the line
diagram won't draw a line between my 2 Y values (that correspont to to the X
values 3/12 and 9/12). I have a lot of data to work with, and now I draw
lines between all points by hand. And that takes a LOT of time. Is there a
better way???

Best regs,

/Anna


All times are GMT +1. The time now is 03:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com