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  

add to values in the chart not on the worksheet



 
 
Thread Tools Display Modes
  #1  
Old October 18th, 2005, 12:20 AM
ab
external usenet poster
 
Posts: n/a
Default add to values in the chart not on the worksheet

Hi,

I have a set of values which I have plotted.

A B
1 1
2 4
3 9
4 16
5 25

Now, I want to add a constant value to values in column B without
calculating them again in a column. I am wondering if i can do this
directly in the "chart dialog box". I will appreciate any help.

Thanks.
  #2  
Old October 18th, 2005, 02:13 AM
Anne Troy
external usenet poster
 
Posts: n/a
Default add to values in the chart not on the worksheet

Perhaps this will help:

http://www.officearticles.com/excel/...worksheets.htm

************
Anne Troy
www.OfficeArticles.com

"ab" wrote in message
...
Hi,

I have a set of values which I have plotted.

A B
1 1
2 4
3 9
4 16
5 25

Now, I want to add a constant value to values in column B without
calculating them again in a column. I am wondering if i can do this
directly in the "chart dialog box". I will appreciate any help.

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Zero values in a log chart Joelle_Smith Charts and Charting 1 December 23rd, 2004 07:58 PM
Chart X axis values are wrong! Sorin Setting Up & Running Reports 0 December 17th, 2004 10:05 PM
Non-Numeric values in X axis of a scatter chart penasm General Discussion 1 October 28th, 2004 05:44 PM
Using a Fomula to Select Chart Values Ken Charts and Charting 4 May 22nd, 2004 10:50 PM
Dynamic Offsetting, Names, Arrays, Range, Chart Values. NEED HELP Bob Lidgard Charts and Charting 14 February 25th, 2004 03:26 PM


All times are GMT +1. The time now is 07:07 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.