Home |
Search |
Today's Posts |
#1
|
|||
|
|||
XL Chart: Separately align series and value data labels
Excel charts should allow me to align the different types of data labels
("Series Name", "Category Name", "Value", etc.) individually when I am using more than one data label type in a column chart. For example, I would like to be able to use the Format Data Labels dialogue box to align a set of Category Name labels "Inside Base" while I align the value labels to "Center". At the base of the column, you would see a category year ("FY 2006") while the center of the column would display a value amount ("$5,634"). I use both Excel 2002 and Excel 2003. -- Stuart Bratesman, Jr., MPP Muskie School of Public Service Univ. of Southern Maine Portland, Maine ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
#2
|
|||
|
|||
You only get one set of data labels per data series. If Excel puts
multiple values within a label, it does so by concatenation, using the separator you specify. To get multiple labels, you could always add an invisible series (line or XY) that has points where you want the labels. Add labels, either manually, or using one of these free Excel add-ins to use cell ranges for the label text: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com/ss - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Stuart Bratesman wrote: Excel charts should allow me to align the different types of data labels ("Series Name", "Category Name", "Value", etc.) individually when I am using more than one data label type in a column chart. For example, I would like to be able to use the Format Data Labels dialogue box to align a set of Category Name labels "Inside Base" while I align the value labels to "Center". At the base of the column, you would see a category year ("FY 2006") while the center of the column would display a value amount ("$5,634"). I use both Excel 2002 and Excel 2003. |
#3
|
|||
|
|||
Jon:
Thank you for your very timely reply, and I appreciate your advice. However, I guess my point would be that Excel would be far more convenient, flexible and responsive if it actually did offer more than one set of data labels per series, that is, one indepent set of labels per label type (series, category, value, etc.) instead of a single concatenated set - with an option to concatenate them if the user were to so choose. Having to resort to adding invisible series (which I have already had too do on too many tiresome occassions) is painfully awkward, totally kludgey, and far beyond the reach of the vast majority of Excel users. After all, software is supposed to make the user's life easier and more productive - and not the opposite. -- Stuart Bratesman, Jr., MPP Muskie School of Public Service Univ. of Southern Maine Portland, Maine "Jon Peltier" wrote: You only get one set of data labels per data series. If Excel puts multiple values within a label, it does so by concatenation, using the separator you specify. To get multiple labels, you could always add an invisible series (line or XY) that has points where you want the labels. Add labels, either manually, or using one of these free Excel add-ins to use cell ranges for the label text: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com/ss - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Stuart Bratesman wrote: Excel charts should allow me to align the different types of data labels ("Series Name", "Category Name", "Value", etc.) individually when I am using more than one data label type in a column chart. For example, I would like to be able to use the Format Data Labels dialogue box to align a set of Category Name labels "Inside Base" while I align the value labels to "Center". At the base of the column, you would see a category year ("FY 2006") while the center of the column would display a value amount ("$5,634"). I use both Excel 2002 and Excel 2003. |
#4
|
|||
|
|||
Stuart -
Agreed, but it still beats paper and pencil (and eraser!). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Stuart Bratesman wrote: Jon: Thank you for your very timely reply, and I appreciate your advice. However, I guess my point would be that Excel would be far more convenient, flexible and responsive if it actually did offer more than one set of data labels per series, that is, one indepent set of labels per label type (series, category, value, etc.) instead of a single concatenated set - with an option to concatenate them if the user were to so choose. Having to resort to adding invisible series (which I have already had too do on too many tiresome occassions) is painfully awkward, totally kludgey, and far beyond the reach of the vast majority of Excel users. After all, software is supposed to make the user's life easier and more productive - and not the opposite. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|