G
girth69
Hi,
I have created a pivot table that displays man-hour bookings from eac
department in a company every month. I have transfered this data onto
pivot chart so that i can see a line graph that shows the increase o
manhour bookings throughout the year from each department.
I have the department number as a field on the left and the months ar
displayed on the x axis. the manhour booking numbers are what is bein
plotted in my chart.
What i need to do now sounds very simple but i cant get it to work.
I need to add in a trendline with an average number that has a constan
increase throught the year e.g 250 per month = 3000 by the end of th
year. All i can seem to do is add a trendline that matches the curren
data. I want a seperate trendline with my own numbers so i can compar
the booked manhours to my own budget manhour trendline. Can this b
done?? When ive tried adding in the data into the pivot table to pul
accross to the chart it adds everything together!
please help
I have created a pivot table that displays man-hour bookings from eac
department in a company every month. I have transfered this data onto
pivot chart so that i can see a line graph that shows the increase o
manhour bookings throughout the year from each department.
I have the department number as a field on the left and the months ar
displayed on the x axis. the manhour booking numbers are what is bein
plotted in my chart.
What i need to do now sounds very simple but i cant get it to work.
I need to add in a trendline with an average number that has a constan
increase throught the year e.g 250 per month = 3000 by the end of th
year. All i can seem to do is add a trendline that matches the curren
data. I want a seperate trendline with my own numbers so i can compar
the booked manhours to my own budget manhour trendline. Can this b
done?? When ive tried adding in the data into the pivot table to pul
accross to the chart it adds everything together!
please help