A
ancient
I am trying to create a Chart using win32::OLE and excel. I have
everything working except generating the background for the Chart.
The command I am using is --
$Excel->ActiveChart->ChartArea->Fill->{Visible} =1;
$Excel->ActiveChart->ChartArea->Fill->{ForeColor}->{SchemeColor} = 17;
$Excel->ActiveChart->ChartArea->Fill->{BackColor}->{SchemeColor} = 2;
$Excel->ActiveChart->ChartArea->Fill->TwoColorGradient({
Style => "msoGradientHorizontal",
Variant => 1 });
Everything seems to work until it hits TwoColorGradient. It finishes
executing, but does not set two colors for the gradient. It just
shows the ForeColor.
I would appreciate any help. I am soooo close!
everything working except generating the background for the Chart.
The command I am using is --
$Excel->ActiveChart->ChartArea->Fill->{Visible} =1;
$Excel->ActiveChart->ChartArea->Fill->{ForeColor}->{SchemeColor} = 17;
$Excel->ActiveChart->ChartArea->Fill->{BackColor}->{SchemeColor} = 2;
$Excel->ActiveChart->ChartArea->Fill->TwoColorGradient({
Style => "msoGradientHorizontal",
Variant => 1 });
Everything seems to work until it hits TwoColorGradient. It finishes
executing, but does not set two colors for the gradient. It just
shows the ForeColor.
I would appreciate any help. I am soooo close!