Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting x axis values on bottom in a logarithmic scale chart | Excel Discussion (Misc queries) | |||
Multiple X and Y Axis labels | Charts and Charting in Excel | |||
multiple x axis labels | Charts and Charting in Excel | |||
Simple question- how to make X axis on bottom of chart | Charts and Charting in Excel | |||
how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel |