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 » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I add an extra line to a line-column chart?



 
 
Thread Tools Display Modes
  #1  
Old February 23rd, 2006, 05:31 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default How do I add an extra line to a line-column chart?

Excel 2003.
I have 3 sets of numbers.
2 sets I want plotted as lines. (These are upper and lower limits of monthly
performance)
The third set of numbers is represent an actual performance; I want this set
represented as columns.
Each set is plotted monthly. (i.e.: x-axis is months of the year.)

  #2  
Old February 23rd, 2006, 05:30 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default How do I add an extra line to a line-column chart?

Make a Line chart
Right click on one line in chart, use Chart type, make Column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"moose" wrote in message
...
Excel 2003.
I have 3 sets of numbers.
2 sets I want plotted as lines. (These are upper and lower limits of
monthly
performance)
The third set of numbers is represent an actual performance; I want this
set
represented as columns.
Each set is plotted monthly. (i.e.: x-axis is months of the year.)



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
creating a bar graph Johnfli General Discussion 0 October 26th, 2005 08:16 PM
How to draw an line chart starting at column 1 Xaver Hinterhuber Charts and Charting 5 June 6th, 2005 08:24 AM
unable to repair inobox Sudheer Mumbai General Discussion 1 February 20th, 2005 11:55 AM
Discontinue part of line in chart Jon Peltier Charts and Charting 0 April 1st, 2004 10:27 PM
Chart - Line Column on 2 Axes Question Patty Charts and Charting 2 November 11th, 2003 10:30 PM


All times are GMT +1. The time now is 01:09 AM.


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