If you want to pad some space between the line graphs and the Y axis, what do you do?
I inserted fictitious columns with no data before the first data column and after the last data column, which seem to do the jub. But there must be a better way.
Padding space between graphs and Y axis
-
- 4StarLounger
- Posts: 437
- Joined: 05 Nov 2012, 20:02
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: Padding space between graphs and Y axis
Under format Axis for the X-Axis, under Axis Options, I check the option to position Axis "Between tick marks" so the points are centered on the lables not at the ends of the chart.
Steve
Steve
-
- Administrator
- Posts: 78473
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Padding space between graphs and Y axis
As Steve notes, when you format the x-axis, you can specify whether the vertical axis crosses on the tick marks or between them:
In the screenshot below, 1. shows "on tick marks" and 2. shows "between tick marks":
In the screenshot below, 1. shows "on tick marks" and 2. shows "between tick marks":
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 437
- Joined: 05 Nov 2012, 20:02
Re: Padding space between graphs and Y axis
Ok, that will kind of achieve what I want. But what if I want those tick marks to sit right on top of the labels (a, b, c, etc., in your example)? Is there a way to have your cake and eat it too here?HansV wrote:As Steve notes, when you format the x-axis, you can specify whether the vertical axis crosses on the tick marks or between them:
In the screenshot below, 1. shows "on tick marks" and 2. shows "between tick marks":
-
- Administrator
- Posts: 78473
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Padding space between graphs and Y axis
Nah, you'd have to add one or more blank entries, as you've been doing.
Best wishes,
Hans
Hans