Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have two columns of data
A B 1 100 2 90 3 110 10 132 20 150 25 152 I used scatter plot to plot column B as Y value and column A as the X value. The plot itself looks fine. However, the x axis label and major ticks are shown at 0, 10, 20, 30, ... What I want is for the x axis label and major ticks to be at 1, 2, 3, 10, 20, 25. In other words, I want to them to correspond to the value in column A. I could not figure out how to do it. Is it doable in Excel. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scatter plot X and y axis equal | Charts and Charting in Excel | |||
changing the x axis in a scatter plot | Charts and Charting in Excel | |||
X axis scale on an XY scatter plot | Charts and Charting in Excel | |||
Double y-axis scatter plot.....? | Charts and Charting in Excel |