chartsmicrosoft excel
Is it possible to have an Excel chart where the axis does NOT start at the major unit?
See the example below, where I want the x-axis to start at the year 2007, but have major unit 5 years and show 2010, 2015 and 2020.
I know you can move the vertical axis using the 'Vertical axis crosses'' setting, but in that case the x-axis is extended to the left of the vertical axis, which is not what I want.
This is what I want:
This is the best I can do (but not good enough, see the yellow marks):
I don't understand quite. What kind of graph do you want ? This ?
To get this, choose your chart as a linear type (xy scatter group). After that go to select data, and select x and y values by hand from series 1. After that, fix up a little your x axis properties, so the year shows every year, and not every two or so ... Might want to fix up the default look of the graph too.
[Back at home now, so have rewritten for Excel 2007]
You can have a "primary" and "secondary" axis in some chart types (line, column and bar at least; maybe others) - they are in pairs so you can't have a secondary x-axis without a secondary y-axis, but you can make the secondary y-axis identical to the primary version, and then hide it, so it has no effect on the graph.
Create your basic chart with the required series.
Right-click the series line for each series that should use the secondary pair of axis, select Format Data Series. And inside the Series Options tab choose Secondary Axis.
Right-click the chart itself and click Select Data.., select on of the series to use the secondary axis and define the Horizontal (Category) Labels.
From the ribbon make the Secondary Axis visible, like so:
Tweak the chart as needed. You may find it useful to use the "more options" option from the image above on the secondary y-axis to ensure it matches your requirements, you can also hide the secondary y-axis, if needed, from the same place.
Can be something like the below image, should give you an idea of what I'm meaning:
(This is a simple contrived graph I've just thrown together, but should get the point across)
Best Answer
The quickest (and I think easiest) way to do this is:
Here's a sample: