Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create a bar graph with three sets of labels
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create a bar graph with three sets of labels
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using excel to create data sets | Excel Discussion (Misc queries) | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
How do i create labels so, could only move and type in labels only | Excel Discussion (Misc queries) | |||
2 different types of data sets displayed on 1 graph | Charts and Charting in Excel | |||
In Excel how do I label the axis of a chart with 2 sets of labels | Charts and Charting in Excel |