Charlie_Chalk
Board Regular
- Joined
- Sep 15, 2002
- Messages
- 93
Hi
I have a chart as follows:
vertical axis=No jobs
Horizontal axis=No days
The chart plots the number of jobs recieved (series 1) and the number of jobs sent out (series 2).
I would like series 3 to be a horizontal line to show the budgetted number of jobs to be sent out. It will be the same number of jobs leaving every day, so it will be horizontal. What I don't want to do (and this is what changes it from being straight forward to me) is have a column full of the same number in the spreadsheet. I would like to create this line from a single cell, is this possible?
CC
I have a chart as follows:
vertical axis=No jobs
Horizontal axis=No days
The chart plots the number of jobs recieved (series 1) and the number of jobs sent out (series 2).
I would like series 3 to be a horizontal line to show the budgetted number of jobs to be sent out. It will be the same number of jobs leaving every day, so it will be horizontal. What I don't want to do (and this is what changes it from being straight forward to me) is have a column full of the same number in the spreadsheet. I would like to create this line from a single cell, is this possible?
CC
