Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
X-axis values in xlLine chart problem
Hi,
I have the following code: $Range = $Sheet-Range( "A3:A93" ); if ($Range) { $Chart-SeriesCollection( 1 )-{XValues} = $Range-{Value}; } it doesn't set the X-axis values as I would expect to "-60, -59, .... 39, 40" instead it displays values "1, 4, 7, .....91". my range contains values "-60" to "40". it works fine if the range contain positive values . any help would be greatly appreciated. -Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem in chart x axis while values are in merged cell | Excel Discussion (Misc queries) | |||
X-axis values in xlLine chart problem | Charts and Charting in Excel | |||
Create excel chart from LotusScript, change xlLine line weight | Excel Programming | |||
Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) | |||
Chart problem: values in column A doen't show on x-axis | Excel Discussion (Misc queries) |