| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How does one make a scatter plot where x or y data are blank?
I want to make several independent xy charts from data in one sheet, i.e.
col. A vs. B, col. C vs. D, etc. Question: must the values be in adjacent columns with the abscissae in the left col.? More importantly, some of my x.y pairs have a blank for one or the other, and the only way I can get a decent plot is to first sort on the x values and plot that range, but that destroys other plots I have made b/c their x values are now scrambled! I haven't found a way around this or any help topic that addresses this. I'm running Excel 2003 on a Solaris platform. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XY Scatter Plot - Non-numeric data | Charts and Charting in Excel | |||
| xy scatter chart-How can you make the axis equal for a 1H:1V plot | Charts and Charting in Excel | |||
| make all markers the same in a scatter plot | Charts and Charting in Excel | |||
| How do I make my data points not overlap in a scatter plot? | Charts and Charting in Excel | |||
| Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
Threaded Mode
