View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Create a bar graph with three sets of labels

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