Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked column graphs and text displayed inside the columns
I want to create a stacked column graph for a series of numbers, then have
corresponding text appear inside the columns. Can this be done in Excel? If not, why do my text boxes disappear (get sent backward) when selecting my graph? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked column graphs and text displayed inside the columns
You could try to use data labels. Right click a series, choose Format, and
for data labels, choose one of the default options. You can edit the text of one of these default labels, or use a utility like one of these to add custom labels from elsewhere in the worksheet: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com If you create a chart, then add textboxes to the worksheet but positioned over the chart, selecting the chart will send the chart to the front while it's active, and you lose sight of the textboxes. Select the chart first, then select the textbox drawing tool and add the textbox, in order to add it to the chart instead of to the worksheet itself. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Garpiper" wrote in message ... I want to create a stacked column graph for a series of numbers, then have corresponding text appear inside the columns. Can this be done in Excel? If not, why do my text boxes disappear (get sent backward) when selecting my graph? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make multi column stacked graphs in Excel | Charts and Charting in Excel | |||
CAN YOU CREATE COLUMNS INSIDE A TEXT BOX | Excel Discussion (Misc queries) | |||
Stacked Column graphs reflecting net totals | Charts and Charting in Excel | |||
How do I combine stacked column and single column graphs? | Excel Discussion (Misc queries) | |||
How do I create two stacked column graphs together? | Excel Discussion (Misc queries) |