| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
if then on chart
I have a spreadsheet with a chart. Instead of graphing a number, I want a
box on the front of the chart that looks at todays date and returns the corresponding number from the spreadsheet. Date Number 1/22/2009 135 1/30/2009 150 2/05/2009 152 2/10/2009 0 So.. Today's date is 2/03/2009 €¦ I would expect to see the number 152 on the chart. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
if then on chart
Hi accesscrazy,
I have a spreadsheet with a chart. Instead of graphing a number, I want a box on the front of the chart that looks at todays date and returns the corresponding number from the spreadsheet. Date Number 1/22/2009 135 1/30/2009 150 2/05/2009 152 2/10/2009 0 So.. Today's date is 2/03/2009 €¦ I would expect to see the number 152 on the chart. Let's say your date table is in cells A1:B5 Then =VLOOKUP(TODAY(),A2:B5,2) will show 152 if today is 2/05/2009 Ed Ferrero www.edferrero.com |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
if then on chart
Awesome! Worked like a charm! Thank you!
"Ed Ferrero" wrote: Hi accesscrazy, I have a spreadsheet with a chart. Instead of graphing a number, I want a box on the front of the chart that looks at todays date and returns the corresponding number from the spreadsheet. Date Number 1/22/2009 135 1/30/2009 150 2/05/2009 152 2/10/2009 0 So.. Today's date is 2/03/2009 €¦ I would expect to see the number 152 on the chart. Let's say your date table is in cells A1:B5 Then =VLOOKUP(TODAY(),A2:B5,2) will show 152 if today is 2/05/2009 Ed Ferrero www.edferrero.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
| Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
| Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
Linear Mode
