Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 5th 08, 02:03 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 1
Default 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.

  #2   Report Post  
Old May 5th 08, 04:48 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default 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
news
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting x axis values on bottom in a logarithmic scale chart Steven Excel Discussion (Misc queries) 2 June 12th 07 06:46 PM
Multiple X and Y Axis labels sdubose99 Charts and Charting in Excel 2 August 7th 06 05:14 AM
multiple x axis labels Mwise Charts and Charting in Excel 2 August 4th 06 08:05 PM
Simple question- how to make X axis on bottom of chart Boon8888 Charts and Charting in Excel 2 February 8th 06 05:13 AM
how to put x axis values in the chart instead of x axis labels Sinclair Charts and Charting in Excel 1 June 21st 05 11:04 AM


All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017