Lookup Data onto graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple graph that collates data from a week. I have a formula in a
cell for the weekly total that transfers minutes into hours. I.E 270/60 =
4.5. On the weekly total graph, I want the total number of hours from the
cell to be displayed at the top next to the heading. So the heading would be;
Total Number of Hours lost 4.5

Can I create a lookup cell on a graph that looks up this data.

Many thanks in advance....
 
I will assume the chart is made and it has a title
Change the formula in the cell to read something like:
="Total Number of Hours Lost " & TEXT(B3/60,"0.00")
Click on the title in the chart; in the Formula Bar type = and point at the
cell with the title; you will see something like =Sheet!$E$2

This works all versions including XL2007.
best wishes
 
Back
Top