Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart showing rates of increase
I am a trainer and have been given the fictitious scenario described below
to test my Excel skills. My question is: What is the best way to build a chart to show the RATES OF INCREASE between Price of Crude Oil and the Cost of Heating Oil for three different companies. Here is he scenario: You are asked to put some learning together for a group of litigation attorneys who will be off site for a trial. They need to learn the easiest way to turn an excel spreadsheet into a chart and put it into PowerPoint presentation. The spreadsheets are not very complex they say. They are tracking the increase in cost of heating oil for three different companies over a five month period against the cost of crude oil. The case is a lawsuit about how heating costs are rising at a much higher rate than the price of crude oil. I'm guessing a chart with lines--one showing the cost of crude oil over the five months and then three other lines showing the costs of heating oil for each of the three companies. Is there some way to show not only the DIFFERENCE in costs, but also the RATE OF CHANGE of the difference in costs? THanks for any help you can give-- Kevin |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart showing rates of increase
The rate of change is
(measure at time t2 - measure at time t1) / (t2 - t1) This gives the slope of the line when measure is plotted against time Without seeing the data I cannot be of more help best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "fennellkevin" wrote in message ... I am a trainer and have been given the fictitious scenario described below to test my Excel skills. My question is: What is the best way to build a chart to show the RATES OF INCREASE between Price of Crude Oil and the Cost of Heating Oil for three different companies. Here is he scenario: You are asked to put some learning together for a group of litigation attorneys who will be off site for a trial. They need to learn the easiest way to turn an excel spreadsheet into a chart and put it into PowerPoint presentation. The spreadsheets are not very complex they say. They are tracking the increase in cost of heating oil for three different companies over a five month period against the cost of crude oil. The case is a lawsuit about how heating costs are rising at a much higher rate than the price of crude oil. I'm guessing a chart with lines--one showing the cost of crude oil over the five months and then three other lines showing the costs of heating oil for each of the three companies. Is there some way to show not only the DIFFERENCE in costs, but also the RATE OF CHANGE of the difference in costs? THanks for any help you can give-- Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to apply a 25% price increase to a column of rates. | Excel Worksheet Functions | |||
Increase a value by a % with result showing in original cell? | Excel Discussion (Misc queries) | |||
Chart Titles not showing in excel chart | Excel Discussion (Misc queries) | |||
Chart Titles not showing in excel chart Window | Excel Discussion (Misc queries) | |||
Line chart for churn rates of many items over time | Charts and Charting in Excel |