| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I center category labels in Excel?
I am trying to center the category labels for a chart in excel...for
clarification, I do not need to center the axis label (example time), I need to center the times themselves. |
|
#2
|
|||
|
|||
|
Sarah -
If Excel has applied a time scaling to the axis, it will often not seem centered. Go to Chart Options on the Chart menu, and on the Axes tab, check Category under Category Axis. If that's not it, perhaps you need to double click the axis, and change the Value Axis Crosses Between Categories setting on the Scale tab (just guessing what else the problem might be). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: I am trying to center the category labels for a chart in excel...for clarification, I do not need to center the axis label (example time), I need to center the times themselves. |
|
#3
|
|||
|
|||
|
Jon,
Unfortunately neither suggestion helped.... "Jon Peltier" wrote: Sarah - If Excel has applied a time scaling to the axis, it will often not seem centered. Go to Chart Options on the Chart menu, and on the Axes tab, check Category under Category Axis. If that's not it, perhaps you need to double click the axis, and change the Value Axis Crosses Between Categories setting on the Scale tab (just guessing what else the problem might be). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: I am trying to center the category labels for a chart in excel...for clarification, I do not need to center the axis label (example time), I need to center the times themselves. |
|
#4
|
|||
|
|||
|
Sarah -
What is the data, how do the labels look, how do you want them to look, and what version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: Jon, Unfortunately neither suggestion helped.... "Jon Peltier" wrote: Sarah - If Excel has applied a time scaling to the axis, it will often not seem centered. Go to Chart Options on the Chart menu, and on the Axes tab, check Category under Category Axis. If that's not it, perhaps you need to double click the axis, and change the Value Axis Crosses Between Categories setting on the Scale tab (just guessing what else the problem might be). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: I am trying to center the category labels for a chart in excel...for clarification, I do not need to center the axis label (example time), I need to center the times themselves. |
|
#5
|
|||
|
|||
|
John,
The data is wage data by industry sector and the labels are the different industry sectors. The labels are fairly long, ie transportation equipment manufacturing, and so they run onto two or three lines. The first line looks centered, but each line beneath it is farther and farther to the left. I want them to be perfectly centered under the first line. I am using the 2003 version of Excel. Sarah "Jon Peltier" wrote: Sarah - What is the data, how do the labels look, how do you want them to look, and what version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: Jon, Unfortunately neither suggestion helped.... "Jon Peltier" wrote: Sarah - If Excel has applied a time scaling to the axis, it will often not seem centered. Go to Chart Options on the Chart menu, and on the Axes tab, check Category under Category Axis. If that's not it, perhaps you need to double click the axis, and change the Value Axis Crosses Between Categories setting on the Scale tab (just guessing what else the problem might be). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: I am trying to center the category labels for a chart in excel...for clarification, I do not need to center the axis label (example time), I need to center the times themselves. |
|
#6
|
|||
|
|||
|
Are the labels entered in the cells as words with single spaces between
them, no spaces before and after the words on the ends, no carriage returns or other non-printing characters? I could reproduce your description by inserting spaces in between and after the words. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: John, The data is wage data by industry sector and the labels are the different industry sectors. The labels are fairly long, ie transportation equipment manufacturing, and so they run onto two or three lines. The first line looks centered, but each line beneath it is farther and farther to the left. I want them to be perfectly centered under the first line. I am using the 2003 version of Excel. Sarah "Jon Peltier" wrote: Sarah - What is the data, how do the labels look, how do you want them to look, and what version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: Jon, Unfortunately neither suggestion helped.... "Jon Peltier" wrote: Sarah - If Excel has applied a time scaling to the axis, it will often not seem centered. Go to Chart Options on the Chart menu, and on the Axes tab, check Category under Category Axis. If that's not it, perhaps you need to double click the axis, and change the Value Axis Crosses Between Categories setting on the Scale tab (just guessing what else the problem might be). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: I am trying to center the category labels for a chart in excel...for clarification, I do not need to center the axis label (example time), I need to center the times themselves. |
|
#7
|
|||
|
|||
|
Yes, they are just single spaced with nothing special. You are right that it
could be fixed by adding spaces to them to line them up, but that seems like a very inefficient method..... "Jon Peltier" wrote: Are the labels entered in the cells as words with single spaces between them, no spaces before and after the words on the ends, no carriage returns or other non-printing characters? I could reproduce your description by inserting spaces in between and after the words. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: John, The data is wage data by industry sector and the labels are the different industry sectors. The labels are fairly long, ie transportation equipment manufacturing, and so they run onto two or three lines. The first line looks centered, but each line beneath it is farther and farther to the left. I want them to be perfectly centered under the first line. I am using the 2003 version of Excel. Sarah "Jon Peltier" wrote: Sarah - What is the data, how do the labels look, how do you want them to look, and what version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: Jon, Unfortunately neither suggestion helped.... "Jon Peltier" wrote: Sarah - If Excel has applied a time scaling to the axis, it will often not seem centered. Go to Chart Options on the Chart menu, and on the Axes tab, check Category under Category Axis. If that's not it, perhaps you need to double click the axis, and change the Value Axis Crosses Between Categories setting on the Scale tab (just guessing what else the problem might be). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: I am trying to center the category labels for a chart in excel...for clarification, I do not need to center the axis label (example time), I need to center the times themselves. |
|
#8
|
|||
|
|||
|
Actually, in my example, they were wrong because of extra spaces, and
fixed by removing these extras. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: Yes, they are just single spaced with nothing special. You are right that it could be fixed by adding spaces to them to line them up, but that seems like a very inefficient method..... "Jon Peltier" wrote: Are the labels entered in the cells as words with single spaces between them, no spaces before and after the words on the ends, no carriage returns or other non-printing characters? I could reproduce your description by inserting spaces in between and after the words. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: John, The data is wage data by industry sector and the labels are the different industry sectors. The labels are fairly long, ie transportation equipment manufacturing, and so they run onto two or three lines. The first line looks centered, but each line beneath it is farther and farther to the left. I want them to be perfectly centered under the first line. I am using the 2003 version of Excel. Sarah "Jon Peltier" wrote: Sarah - What is the data, how do the labels look, how do you want them to look, and what version of Excel are you using? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: Jon, Unfortunately neither suggestion helped.... "Jon Peltier" wrote: Sarah - If Excel has applied a time scaling to the axis, it will often not seem centered. Go to Chart Options on the Chart menu, and on the Axes tab, check Category under Category Axis. If that's not it, perhaps you need to double click the axis, and change the Value Axis Crosses Between Categories setting on the Scale tab (just guessing what else the problem might be). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Sarah wrote: I am trying to center the category labels for a chart in excel...for clarification, I do not need to center the axis label (example time), I need to center the times themselves. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel charts should let me select a range for data labels. | Charts and Charting in Excel | |||
| how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) | |||
| How do I center data across multiple cells in excel without mergi. | Excel Discussion (Misc queries) | |||
| print labels from excel with title and number | Excel Discussion (Misc queries) | |||
| Merge and Center Disabled in Excel 2003 Document | Charts and Charting in Excel | |||
Linear Mode
