View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Caco Caco is offline
external usenet poster
 
Posts: 4
Default Create a bar graph with three sets of labels

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