Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Store variable value for Chart
The value of a cell changes randomly during the day as a
result of a web query i.e. at 10:00 AM the value is 2.3 at 10:15 AM the value is 2.54 etc. How can I store the individual values so that I can create a chart that depicts these changes graphically. Many thanks Al |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Store variable value for Chart
You need to have a variable to store the target row number and incremen
it with each cycle of the macro (don't forget to initialise it at th beginning of the macro with rw=0 or whatever). Something like :- '-------------------------------------------------------------------- rw = rw + 1 Worksheets("DataStore").Cells(rw, 1).Value = MyTime Worksheets("DataStore").Cells(rw, 2).Value = MyValue '---------------------------------------------------------------------- -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need variable time axis available in XY chart for area chart | Charts and Charting in Excel | |||
need variable time axis available in XY chart for area chart | Charts and Charting in Excel | |||
store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
How can I store individual chart settings | Charts and Charting in Excel | |||
Chart with both X & Y variable | Charts and Charting in Excel |