Changing location of axis labels

JeffM · #1 01-14-2017, 03:11 PM

Quote:

Originally Posted by jeffreybrown

I believe you should attach a sample workbook so we can understand what you are working with.

I cannot figure out how to provide a copy of the chart itself.

An example of the basic problem is this.

Qtr 1 Qtr 2 Qtr 3 Qtr 4

A 120 90 50 80
B 20 70 110 70
Delta 100 20 -60 10

If you set up a chart that is a line chart for the three rows above and you want to label the data points as Qtr 1, Qtr 2, etc., those labels show up in the middle of the chart (below the line y = 0 but well above y = - 60) rather than below the bottom axis.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select which labels to display on horizontal axis on line chart	Jack H	Excel	5	01-13-2016 10:05 AM
changing the spread sheet location on embeded pie chart	otuatail	PowerPoint	1	03-04-2014 07:20 AM
Changing the location of the inbox	Yamipirogoeth	Outlook	0	09-26-2013 09:59 AM
Syncing OneNote with Skydrive after changing location	Keptenjim	OneNote	0	05-20-2013 11:43 PM
Changing default delivery location<<	geoff.s	Outlook	1	03-09-2011 04:26 PM