#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 26
Default line graph

I would like to add a small amount of text over a line graph e.g. "December
sales were high" to explain a sudden rise in the line. I am printing charts
from chart sheets and they are not embeded on a worksheet. Is there a way to
do it? Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default line graph

In 2003 and earlier, you can just select the chart, type what you want, and
press Enter. You'll get a textbox in the middle of the chart that you can
drag around and format. In 2007 you have to select the chart, then from the
Insert tab, choose TextBox or another shape.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jamal" wrote in message
...
I would like to add a small amount of text over a line graph e.g. "December
sales were high" to explain a sudden rise in the line. I am printing
charts
from chart sheets and they are not embeded on a worksheet. Is there a way
to
do it? Thanks.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 26
Default line graph

Jon, thanks. It works.

Jamal

"Jon Peltier" wrote:

In 2003 and earlier, you can just select the chart, type what you want, and
press Enter. You'll get a textbox in the middle of the chart that you can
drag around and format. In 2007 you have to select the chart, then from the
Insert tab, choose TextBox or another shape.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jamal" wrote in message
...
I would like to add a small amount of text over a line graph e.g. "December
sales were high" to explain a sudden rise in the line. I am printing
charts
from chart sheets and they are not embeded on a worksheet. Is there a way
to
do it? Thanks.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
average Line created in an existing line graph- based on one cell Melanie Charts and Charting in Excel 2 December 27th 07 09:14 PM
How do I graph data daily as a line graph across a calendar format Glani Charts and Charting in Excel 3 November 23rd 07 09:05 AM
How do I make a line graph WITHOUT first line starting at zero? NorthStar Charts and Charting in Excel 9 September 7th 07 02:31 PM
How to change color of line and point markers on a line graph SASPerson Charts and Charting in Excel 1 November 15th 06 06:43 PM
Cluster stacked graph AND line combo graph? [email protected] Charts and Charting in Excel 6 October 14th 06 12:33 AM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"