Hi,
If the information aligns with the current x axis labeling you could use a
dummy series on the secondary axis.
Then you the secondary x-axis label to display the extra text.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Caco" wrote in message
...
I have a bar chart with the following data
Depth (on left side axis of graph) - 50, 100, 150, 200 etc
No of blows (on bottom axis of graph) - 1, 2, 3.... 10
I would like to add labels to the top axis of the chart, showing the
correlation between no of blows and CBR values. ie 1 blow = CBR 3.5,
2=8,
3=13, 4=18....
I have faked it by using a text box showing the CBR's at the top of the
chart, but would prefer an actual set of labels
Any ideas out there?
Ideas please