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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 04:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com