| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
I'm nto charts, please be nice. (Bar graph question)
I have a bar graph and when the numbers are populated, they set on top of the
bar. Is there away to have the number huver/float above the bar? I have 6 bar graphs and I have to click on the amonts and move it up some so your able to see the number and no, my boss will not let me use the background "opaque". Thanks |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I'm nto charts, please be nice. (Bar graph question)
Hi,
Right click the data labels and on the Alignment tab is a droplist containing Label Positions. Try the Outside End position. Cheers Andy pgarcia wrote: I have a bar graph and when the numbers are populated, they set on top of the bar. Is there away to have the number huver/float above the bar? I have 6 bar graphs and I have to click on the amonts and move it up some so your able to see the number and no, my boss will not let me use the background "opaque". Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I'm nto charts, please be nice. (Bar graph question)
Sorry, I should have pointed out that I have Off2k. I have: left, right,
center and justify only. "Andy Pope" wrote: Hi, Right click the data labels and on the Alignment tab is a droplist containing Label Positions. Try the Outside End position. Cheers Andy pgarcia wrote: I have a bar graph and when the numbers are populated, they set on top of the bar. Is there away to have the number huver/float above the bar? I have 6 bar graphs and I have to click on the amonts and move it up some so your able to see the number and no, my boss will not let me use the background "opaque". Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I'm nto charts, please be nice. (Bar graph question)
Those are the options for text alignment.
Below those 2 dropdowns, Horizontal and Vertical Text Alignment, is the Label Position dropdown. I just checked in XL2K. Cheers Andy pgarcia wrote: Sorry, I should have pointed out that I have Off2k. I have: left, right, center and justify only. "Andy Pope" wrote: Hi, Right click the data labels and on the Alignment tab is a droplist containing Label Positions. Try the Outside End position. Cheers Andy pgarcia wrote: I have a bar graph and when the numbers are populated, they set on top of the bar. Is there away to have the number huver/float above the bar? I have 6 bar graphs and I have to click on the amonts and move it up some so your able to see the number and no, my boss will not let me use the background "opaque". Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I'm nto charts, please be nice. (Bar graph question)
Is that a 3d chart by any chance?
pgarcia wrote: Sorry, I should have pointed out that I have Off2k. I have: left, right, center and justify only. "Andy Pope" wrote: Hi, Right click the data labels and on the Alignment tab is a droplist containing Label Positions. Try the Outside End position. Cheers Andy pgarcia wrote: I have a bar graph and when the numbers are populated, they set on top of the bar. Is there away to have the number huver/float above the bar? I have 6 bar graphs and I have to click on the amonts and move it up some so your able to see the number and no, my boss will not let me use the background "opaque". Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I'm nto charts, please be nice. (Bar graph question)
If it's a bar, he can't float above the bar. Outside end is to the right.
(Yeah, I know, most people say bar when they mean column.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Is that a 3d chart by any chance? pgarcia wrote: Sorry, I should have pointed out that I have Off2k. I have: left, right, center and justify only. "Andy Pope" wrote: Hi, Right click the data labels and on the Alignment tab is a droplist containing Label Positions. Try the Outside End position. Cheers Andy pgarcia wrote: I have a bar graph and when the numbers are populated, they set on top of the bar. Is there away to have the number huver/float above the bar? I have 6 bar graphs and I have to click on the amonts and move it up some so your able to see the number and no, my boss will not let me use the background "opaque". Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I'm nto charts, please be nice. (Bar graph question)
Hi Jon,
Your right if it is really a bar chart then above would not be an option. But Outside end should still be available. Here are a few suggests for a bar chart. You could add another series and use that to display the data label centered. Format the second series to have no fill or border. With this the displayed bar is slightly off centered. Or add a duplicate series with 1 extra point at the beginning, which has no data. Place this series on the secondary axis. Again format no fill or border. Display data label centered. Now in order to lift the label above the bar you will need to add the secondary X Axis. Format the secondary X axis to not have Value (Y) axis crosses between categories. This will offset the bars enough to make the data labels above above the bars on the primary axis. Add XY Scatter series. X values would be half of bar value. Y values would be 0.5, 1.5 etc The data label position can be set to above and in order to display the correct value you would need to link the data labels to cells containing the true values. Try Rob Bovey's free add-in for labeling. http://www.appspro.com/Utilities/ChartLabeler.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Jon Peltier" wrote in message ... If it's a bar, he can't float above the bar. Outside end is to the right. (Yeah, I know, most people say bar when they mean column.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Is that a 3d chart by any chance? pgarcia wrote: Sorry, I should have pointed out that I have Off2k. I have: left, right, center and justify only. "Andy Pope" wrote: Hi, Right click the data labels and on the Alignment tab is a droplist containing Label Positions. Try the Outside End position. Cheers Andy pgarcia wrote: I have a bar graph and when the numbers are populated, they set on top of the bar. Is there away to have the number huver/float above the bar? I have 6 bar graphs and I have to click on the amonts and move it up some so your able to see the number and no, my boss will not let me use the background "opaque". Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I'm nto charts, please be nice. (Bar graph question)
Yes, it was, but have now changed it and I get the other option. Thank
"Andy Pope" wrote: Is that a 3d chart by any chance? pgarcia wrote: Sorry, I should have pointed out that I have Off2k. I have: left, right, center and justify only. "Andy Pope" wrote: Hi, Right click the data labels and on the Alignment tab is a droplist containing Label Positions. Try the Outside End position. Cheers Andy pgarcia wrote: I have a bar graph and when the numbers are populated, they set on top of the bar. Is there away to have the number huver/float above the bar? I have 6 bar graphs and I have to click on the amonts and move it up some so your able to see the number and no, my boss will not let me use the background "opaque". Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I'm nto charts, please be nice. (Bar graph question)
"Andy Pope" wrote in message ... Hi Jon, Your right if it is really a bar chart then above would not be an option. But Outside end should still be available. That's right. I assumed the OP correctly said bar chart, but looked at alignment in the incorrect dialog. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word & Excel - Nice question | Excel Worksheet Functions | |||
| creating xy graph charts for algebra class | Excel Discussion (Misc queries) | |||
| multiple pie charts on same graph | Charts and Charting in Excel | |||
| Displaying graph and charts on events | Excel Discussion (Misc queries) | |||
| Nice | Excel Discussion (Misc queries) | |||
Linear Mode
