Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting Point on Gridline
I have a graph that I made but I'm having an issue with the points being
plotted on it. It's a custom type chart (lines on 2 axes). I have everything on there and it is all working, but my points are being shown in between my x axis values instead of on the gridline. ie: if the data is associated with 80,000 sq ft it shows the point in the space between 80,000 and 90,000 sq ft rather than on the gridline for 80,000 sq ft. Is there any way to change this so that the point will appear on the 80,000 sq ft gridline? I'm not sure that I described this well, but I tried. I would appreciate any help that you can offer. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting Point on Gridline
Hi,
Try, double clicking the category axis and on the scale tab uncheck the Y (value axis) crosses between categories. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "lblunier" wrote in message ... I have a graph that I made but I'm having an issue with the points being plotted on it. It's a custom type chart (lines on 2 axes). I have everything on there and it is all working, but my points are being shown in between my x axis values instead of on the gridline. ie: if the data is associated with 80,000 sq ft it shows the point in the space between 80,000 and 90,000 sq ft rather than on the gridline for 80,000 sq ft. Is there any way to change this so that the point will appear on the 80,000 sq ft gridline? I'm not sure that I described this well, but I tried. I would appreciate any help that you can offer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom gridline - one single gridline at a specific value | Charts and Charting in Excel | |||
Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
Plotting X and Y to a single point | Charts and Charting in Excel | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
plotting 2 variables as scatter and naming each point | Charts and Charting in Excel |