If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Putting text into graph
I have a bar graph, and want to add text to the graph. The text is numbers
that are found in the line below the vaules for the bar graph. Is their a way that i can have it so this text automatically calculates, and i do not need to type it everytime i change the graph |
#2
|
|||
|
|||
Putting text into graph
Hi Kirsty,
check out this video http://www.datapigtechnologies.com/f...hartlabel.html "Kirsty" wrote in message ... I have a bar graph, and want to add text to the graph. The text is numbers that are found in the line below the vaules for the bar graph. Is their a way that i can have it so this text automatically calculates, and i do not need to type it everytime i change the graph |
#3
|
|||
|
|||
Putting text into graph
Hi,
You should download the free XL Chart Labeler add in for Excel it save having to do what you want manually for each data point. http://www.appspro.com/Utilities/ChartLabeler.htm What this utility does is automate the following manual steps: 1. Right click the series and choose Format Data Series 2. On the Data Labels tab choose Values and click OK. 3. Single click one of the data labels and on the Formula Bar type = 4. Click on the cell in the spreadsheet that whose number you want displayed in the data label and press Enter. 5. Repeat for each data label. The data labels are now linked to the cells in the spreadsheet and will update automatically when the data changes. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Kirsty" wrote: I have a bar graph, and want to add text to the graph. The text is numbers that are found in the line below the vaules for the bar graph. Is their a way that i can have it so this text automatically calculates, and i do not need to type it everytime i change the graph |
#4
|
|||
|
|||
Putting text into graph
thanks, that works a treat
"Mike Alexander" wrote: Hi Kirsty, check out this video http://www.datapigtechnologies.com/f...hartlabel.html "Kirsty" wrote in message ... I have a bar graph, and want to add text to the graph. The text is numbers that are found in the line below the vaules for the bar graph. Is their a way that i can have it so this text automatically calculates, and i do not need to type it everytime i change the graph |
Thread Tools | |
Display Modes | |
|
|