data markers in graphs overlap
When I make a point graph in excel, some of my data points are positioned
exactly on top of each other. That's a problem, because my winter data has the same value as my summer data. But now I can not see whether my summer data is hidden behind my winter data or that maybe my summer data is altogether flawed and not in my graph at all. Of course I can use different markers for both data types, but I'd rather use an offset option or something like that. I use Excel 2003 |
data markers in graphs overlap
If it's not going to upset the display of values, you can jitter the data,
that is, add or subtract a slight X or Y offset to the data. This is not something the chart does, it's something you have to do to the data before the chart gets it. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Hopsakee" wrote in message ... When I make a point graph in excel, some of my data points are positioned exactly on top of each other. That's a problem, because my winter data has the same value as my summer data. But now I can not see whether my summer data is hidden behind my winter data or that maybe my summer data is altogether flawed and not in my graph at all. Of course I can use different markers for both data types, but I'd rather use an offset option or something like that. I use Excel 2003 |
All times are GMT +1. The time now is 04:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com