total noob to charting/pivot, best way to display the data graphically

Hi guru's

So I have a project that has a budget and the guidelines from finance is, forget any extra funding.

I just want some ideas on what can be done with charts/pivots. I have no idea how to use these.

Have a look at the attached, this is all the information we need to capture.

Whats the best way to display the actual cost and the expected costs in a pretty way for management.

Bump.
10char

Like I said, I am a total noob when it comes to charting data, which is probably why it isn't organized correctly.

All calculations appear on the Calculations tab

Row 4 is the fortnight totals of normal time, as in not overtime/penalties rates
Row 5 is a running total, for exampleFN1 + FN2 equals, etc

Row 7 and 8 are the same as above just totaling the overtime

Row 9 is the total of Normal and overtime rates
Row 10 is the budget for a expected

Does that help in any way?

My 'vision' would be to have a line graph showing the budget from 0(zero) to 50,000(example) in a straight line(excuse my terms), Then plot the overall costs on another line

Maybe a separate graph showing normal and overtime costs/

Thanks for all the help guys..

Thanks for the rep!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."