Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Markers | Charts and Charting in Excel | |||
Too many markers on line chart makes it a thick line and individual markers cannot be seen | Excel Discussion (Misc queries) | |||
how to overlap 2 graphs/2 scales to relay information | Charts and Charting in Excel | |||
Custom Data Markers? | Charts and Charting in Excel | |||
Can I overlap only two of four data series in Excel Column Chart? | Charts and Charting in Excel |