| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Force X Axis Label
How do I force Excel to Label every bar on a bar chart? I have a simple bar
chart that I would like to have the X Axis Label on every bar except Excel skips and labels every other one. How do I force it to label each one? -- Thanks As Always Rip |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Force X Axis Label
If you mean the labels along the x-axis, double-click the x-axis. In the
resulting dialog box, in the Scale tab, adjust the value in the 'Number of categories between tick-mark labels'. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "Ripper" wrote: How do I force Excel to Label every bar on a bar chart? I have a simple bar chart that I would like to have the X Axis Label on every bar except Excel skips and labels every other one. How do I force it to label each one? -- Thanks As Always Rip |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Force X Axis Label
Hi,
Double click axis and on the scale tab adjust the Number of Categories between tick labels. Cheers Andy Ripper wrote: How do I force Excel to Label every bar on a bar chart? I have a simple bar chart that I would like to have the X Axis Label on every bar except Excel skips and labels every other one. How do I force it to label each one? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Force X Axis Label
Worked great! Thank you.
-- Thanks As Always Rip "Tushar Mehta" wrote: If you mean the labels along the x-axis, double-click the x-axis. In the resulting dialog box, in the Scale tab, adjust the value in the 'Number of categories between tick-mark labels'. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "Ripper" wrote: How do I force Excel to Label every bar on a bar chart? I have a simple bar chart that I would like to have the X Axis Label on every bar except Excel skips and labels every other one. How do I force it to label each one? -- Thanks As Always Rip |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom axis label frequency | Charts and Charting in Excel | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Y Axis Label is Cutoff | Charts and Charting in Excel | |||
| Category axis label problem at column chart | Charts and Charting in Excel | |||
| Text Truncated on Vertical Chart Axis Label | Excel Discussion (Misc queries) | |||
Linear Mode
