Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar chart x axis labelling
Can anyone tell me if it is possible to have two labels on the x axis of a
bart chart. For example if I have 6 bars in 2 groups of three can I label the groups 1 and 2 and the individual bars i, ii, iii, iv, v, and vi. I know one can do this by having a legend, but I want to have all the labels below the X axis in line with the relevent bar. MAny thanks J |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar chart x axis labelling
You can fake it. Rearrange your data as shown, where [x] indicates data, and
make a stacked column chart (view in non-proportional font). Grp1 Grp2 i [x] ii [x] iii [x] iv [x] v [x] vi [x] This produces uniformly spaced columns. To get a column to touch adjacent columns, double click on one column, and on the Options tab, change Gap Width to zero. The data arrangement above does not provide for a second row of category axis labels. To get these, insert a column. Grp1 Grp2 A i [x] ii [x] B iii [x] iv [x] C v [x] vi [x] The A-B-C labels will be centered below each pair of i-ii, iii-iv, v-vi labels. To get a space between groups A, B, and C, you need to insert rows, and put a space, [s], in the first cell of each inserted row: Grp1 Grp2 i [x] ii [x] [s] iii [x] iv [x] [s] v [x] vi [x] or Grp1 Grp2 A i [x] ii [x] [s] B iii [x] iv [x] [s] C v [x] vi [x] - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "JRD" wrote in message ... Can anyone tell me if it is possible to have two labels on the x axis of a bart chart. For example if I have 6 bars in 2 groups of three can I label the groups 1 and 2 and the individual bars i, ii, iii, iv, v, and vi. I know one can do this by having a legend, but I want to have all the labels below the X axis in line with the relevent bar. MAny thanks J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination chart: primary data labels obscure line series on secondary axis | Charts and Charting in Excel | |||
Making a chart that uses a secondary Y axis | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel |