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

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

Hi,

This is a little tricky but there is a built-in way to do it: Suppose your
data looks like this

Depth Blows CBR
50 1 3.5
100 2 8
150 3 13
200 4 18
250 5 22.75
300 6 27.6
350 7 32.45
400 8 37.3
450 9 42.15
500 10 47

Assume this data start in A1.

1. Plot your chart with the first 2 data sets as series.
2. Right-click on the series you want on the right-hand axis and choose
Format Data Series, Axis tab, Secondary Axis, OK
3. With the chart selected choose Chart, Chart Options, Axis tab, check the
box under Secondary axis called Category (X) axis, OK
4. With the chart selected choose Chart, Source Data, Series tab, click in
the box titled Second category (X) axis labels and highlight the range with
the CBR data, in my data set that in C2:C10, OK.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Caco" wrote:

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

Thanks for the detailed help Shane.
However, there is an issue with step three. The tick box is greyed out.

"Shane Devenshire" wrote:

Hi,

This is a little tricky but there is a built-in way to do it: Suppose your
data looks like this

Depth Blows CBR
50 1 3.5
100 2 8
150 3 13
200 4 18
250 5 22.75
300 6 27.6
350 7 32.45
400 8 37.3
450 9 42.15
500 10 47

Assume this data start in A1.

1. Plot your chart with the first 2 data sets as series.
2. Right-click on the series you want on the right-hand axis and choose
Format Data Series, Axis tab, Secondary Axis, OK
3. With the chart selected choose Chart, Chart Options, Axis tab, check the
box under Secondary axis called Category (X) axis, OK
4. With the chart selected choose Chart, Source Data, Series tab, click in
the box titled Second category (X) axis labels and highlight the range with
the CBR data, in my data set that in C2:C10, OK.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Caco" wrote:

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