| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
X-axis variable reference
Hi! I am having trouble with constructing an x-axis in my macro for excel.
since the x-axis changes all the time I want to have a dynamic reference. The code now is: ActiveChart.SeriesCollection(1).XValues = rng1.Address rng1.Offset(i, 0).Address As you can see the right hand side is incorrect. However I do not know how to refer to the cells. Please help me out on this one!!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
X-axis variable reference
ActiveChart.SeriesCollection(1).XValues = rng1.parent.Range(rng1, _
rng1.Offset(i,0)).Address(1,1,xlA1,True) -- Regards, Tom Ogilvy "april27" wrote: Hi! I am having trouble with constructing an x-axis in my macro for excel. since the x-axis changes all the time I want to have a dynamic reference. The code now is: ActiveChart.SeriesCollection(1).XValues = rng1.Address rng1.Offset(i, 0).Address As you can see the right hand side is incorrect. However I do not know how to refer to the cells. Please help me out on this one!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Axis Length | Charts and Charting in Excel | |||
| Using a cell reference as the axis value for Horizontal axis crosses | Charts and Charting in Excel | |||
| How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
| How do I set Line chart y Axis variable X axis value? | Charts and Charting in Excel | |||
| Using Right Hand Y Axis For An Additional Variable: How ? | Charts and Charting in Excel | |||
Hybrid Mode
