Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label plotted on graph area
I have some graphs where some of the y values are negative. Hence zero is halway up the graph (as one woul expect)
The x axis labels are being plotterd by default under the zero, however this means they are on the graph plot itself making the values difficult to read How do I force the labels to be arranged below the graph itself (like where you would expect to see them and why does it want to plot them, on the graph with this type o data Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label plotted on graph area
Dave,
the default setting is for the X-axis to cross the Y-axis at 0. To override this, and display the X values below the graph, right click on the Y-axis, select "Format axis", click the "scale" tab. You will see that: "Category (X) axis crosses at:" is set to zero. Change the zero to whatever the lowest value on your Y-axis is and OK. The X- Axis labels will now be displayed below the chart. However, you will no longer have a nice, easily distinguished line at 0 on the Y-axis. If this bothers you, have a look at Jon Peltier's method for adding a dummy series into the chart. http://peltiertech.com/Excel/Charts/...orzSeries.html Cheers, Pete. -----Original Message----- I have some graphs where some of the y values are negative. Hence zero is halway up the graph (as one woul expect). The x axis labels are being plotterd by default under the zero, however this means they are on the graph plot itself making the values difficult to read. How do I force the labels to be arranged below the graph itself (like where you would expect to see them and why does it want to plot them, on the graph with this type o data? Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label plotted on graph area
Thanks Peter
In a convoluted way this solved my problem. Actually this is controlled by the CrossesAt property so as long as i set this based on my series i9t will solve my question Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to find the lowest point on the plotted line in a graph. | Charts and Charting in Excel | |||
can I find the area under a plotted curve? | Excel Worksheet Functions | |||
Calculation of Area Under a Plotted Graph | Excel Worksheet Functions | |||
graph does not show all plotted points | Charts and Charting in Excel | |||
Is there a way to have the plotted area of an excel graph to have. | Charts and Charting in Excel |