ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Multiple Axis Labels, Top AND Bottom (https://www.excelbanter.com/charts-charting-excel/186224-multiple-axis-labels-top-bottom.html)

Rick N

Multiple Axis Labels, Top AND Bottom
 
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.

Jon Peltier

Multiple Axis Labels, Top AND Bottom
 
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
_______


"Rick N" wrote in message
...
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.





All times are GMT +1. The time now is 12:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com