ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   X-axis values in xlLine chart problem (https://www.excelbanter.com/charts-charting-excel/109207-x-axis-values-xlline-chart-problem.html)

Gary

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.

my range contains values "-60" to "40".

it works fine if the range contain positive values .

any help would be greatly appreciated.

-Gary



All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com