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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i plot last n data point
I am using the excel 2000 formulas book on charts Iam trying to create a
chart that plots the most recent 12 data inputs. but when I try to follow the book on replacing the range referances it keeps putting errors up saying the fomula does not work. The formula is =series(,sheet1!dates,sheet1!sales,1). can someone help |
#2
|
|||
|
|||
what you ned to do is to create a dynamic range see this referenece for a guide http://www.contextures.com/xlNames01.html#Dynamic -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=276010 |
#3
|
|||
|
|||
See Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html particularly example #2 -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am using the excel 2000 formulas book on charts Iam trying to create a chart that plots the most recent 12 data inputs. but when I try to follow the book on replacing the range referances it keeps putting errors up saying the fomula does not work. The formula is =series(,sheet1!dates,sheet1!sales,1). can someone help |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Source issues. ??data.access.pages | Phil | Database Design | 2 | October 11th, 2004 02:42 AM |
create data point line in a column chart | Annie | Charts and Charting | 1 | February 20th, 2004 04:07 AM |