How to insert X axis scale values next to axis and X axis grid lin


    Sponsored Links


  • 1. move the point horizontally if it lie on top of the other point
    I am trying to plot a line chart with a primary axis as category X axis (there are 4 categories) and a value Y axis. I don't want any line to connect the points. I just have symbols to show the values. The chart works fine. The problem is in each category there are some same values and they show as a single point on the graph, because one lie on top of the other. How do move the points horizontally if there is more than one point at the same place. I want to show that there are more than one points. Thanks Sheela
  • 2. Newbie - Insert picture and lock to cell
    Is there a way of inserting a picture into a specific cell rather than having it as a 'floating' image, not locked to a cell?
  • 3. Crashing when changing existing chart
    I currently run the Tablet version of Windows XP and also have Office XP. Whenever I set up a chart in Excel and save the entire workbook and then go back and attempt to make changes to the chart it crashes Excel. I can always recover the file but I can never change that chart. However, when I put the exact same file on my home computer which runs Windows XP standard and Office XP I can change the chart with no problems. Any suggestions
  • 4. If-formula in series-range of chart-datasource
    Hello there, depending on the "True" or "False"-value of a checkbox in a worksheet, I need to show one or the other dataseries for the X-axis in an XL-chart. However, when I try to integrate an If-formula into the series-definition in the datasource-dialogbox, Excel doesn't accept that. Is there a way to make a dataseries shown dependent on a condition ? Thank you in advance, Kind regards, H.G. Lamy

How to insert X axis scale values next to axis and X axis grid lin

Postby dnAyM2xhcnJ5 » Fri, 24 Jun 2005 23:16:02 GMT

I usually create charts with logarithmic scale on the X axis.
I find that using "Scatter" chart function allows this to be done easily.
The final chart inserts the grid ticks but does not insert X axis values (or 
even grid lines).
Does anyone know the simple way to achieve what I want?

RE: How to insert X axis scale values next to axis and X axis grid lin

Postby QmFyYiBSLg » Fri, 24 Jun 2005 23:26:02 GMT

What is the min/max value for your X axis?   As I recall, only axis labels 
are put only for each decade, and not for anything in the middle.  (shows 
0.1, doesn't show 0.2-0.9, shows 1).  You can do that, but it requires some 
additional work.

RE: How to insert X axis scale values next to axis and X axis grid lin

Postby Q29sbGluczMy » Fri, 24 Jun 2005 23:45:13 GMT

Min is 10, max is 1000. major axis values of 10, 100, 1000 is desiredalong 
with major grid lines.

Similar Threads:

1.The scale on vertical axis equals to scale on vertical axis of ano


I have a chart that displays 'before product implementation' scenario and 
another one next to it that dispalys 'after product implementation'. The user 
will have two countries to choose from so I have to leave the scale on auto 
rather than fix it because the the countries have very different size 

What I would like to do is to make the vertical scale of graph 1 equal to 
the vertical scale of graph 2 so that I can show the impact of the product 
more clearly. Is there a way to do this which doesn't involved fixing the 

Many thanks in advance.



2.How do I reference x-axis or y-axis scale values to a worksheet ce

I would like to have a chart's x-axis or y-axis scale values (min, max, major 
unit, minor unit, etc) reference a data cell. This way I could manually 
change the scaling of the graph from the worksheet or have it scale 
automatically depending on the input data.

OR if anyone knows how to simply have excel equate the x-axis and y-axis 
scales, that would be awesome too. (ie. if a box (therefore equal sides) was 
drawn in a xy scatter graph, it would look like a box in the chart, not a 

Thanks in advance

3.Need PivotChart x axis to cross Y axis at minimum Y axis value

I see an option to have x cross y at max y, but how can I say min y?

4.dual y-axis align grid, drop line to y axis, add-ins

1.  Is there a way of scaling two y axis so that the grid lines intersect at 
a specified integer on both axes, other than trial-and-error?

2. Other than drawing one, how would one drop a perpendicular line (s)from a 
plotted line to the y axis?

3. Any recommendations for free and paid (please specify) add-ins for excel 
2007 charts?

Thanks in a advance,

John (SAS programmer who must use excel)

5.x axis alignment w/pos-neg y axis scale

Excel defaults the alignment of the months to the center 
of the chart ~ I would like to move them to the bottom of 
the chart.  

6. How to make Primary axis and Secondary X-axis have the same scale

7. Excel: secondary Y axes with log-scale X axis

8. Adding data on Axis Major Gridlines next to Category Axis Collums

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 12 guest