A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need help with Graph Labels



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2010, 08:31 AM posted to microsoft.public.excel.setup
Ashpoint
external usenet poster
 
Posts: 30
Default Need help with Graph Labels

I have (what I think) is a simple graph and I want to add event titles.

Consider a list of colums:
Dates
Value
Event_Text

A typical set of rows would be:

04 Jan 2010 1000 Begining
....
....
....
10 March 2010 2134 Mary Birthday
.....
....
....
17 April 2010 1764 Move House


I'm able to have a line graph that shows the dates and figures as well as
labels for the dates and values. I even have a block marker showing on the
three event dates.

How do I get the event labels to print on the graph? In other words, I
want the words "Move House" to appear on the graph on the 17 April 2010

(Hopefuily I have explained sufficienty) - I'm happy to upload a populated
spreadsheet given an understanding how to attach or send the file.

BTW - The Excel versionis 2010 but I think the same solution will be
applicable for Excel 2007 as well.



  #2  
Old May 5th, 2010, 06:44 PM posted to microsoft.public.excel.setup
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Need help with Graph Labels

EXCEL 2007

I have just put up a chart for you at:-

http://www.pierrefondes.com/

Item number 102.

It's not quite what you want but it may suffice.

The other thing that you could do is to use Text Boxes.

If my comments have helped please hit Yes.

Thanks.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:02 PM.


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