Multiple Axis Labels, Top AND Bottom

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick N - 05 May 2008 14:03 GMT

I am plotting a weightloss series with weekly values. I currently have the
horizontal (subject) axis values labeled with a series of dates from the
spreadsheet. I have set the date axis labels at the bottom. How can I add a
second set of labels at the top for the same axis?. For each axis, I want
date label at the bottom and loss-from-last-week label at the top. The
actual weight is plotted in the line chart.

Reply to this Message

Jon Peltier - 05 May 2008 16:48 GMT

I would add a new series with XY points of Y = Y axis maximum and X = date.
Then I would apply data labels using worksheet calculated cells, with one of
these utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

I would then hide the new series, or use a small cross to mimic tickmarks.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

>I am plotting a weightloss series with weekly values. I currently have the
> horizontal (subject) axis values labeled with a series of dates from the
[quoted text clipped - 3 lines]
> date label at the bottom and loss-from-last-week label at the top. The
> actual weight is plotted in the line chart.

Reply to this Message