Select Code to Download

OLE exception from "Microsoft Office Excel":

Unable to set the HasTitle property of the Chart class

Win32::OLE(0.1707) error 0x80020009: "Exception occurred"
    in PROPERTYPUT "HasTitle" at Processor.pl line 1044

$mcr_crtime_chart->{HasTitle} = 1;
    $mcr_crtime_chart->ChartTitle->{Text} = "MCRByURN-CreateTime";

OLE exception from "Microsoft Office Excel":

Unable to set the Position property of the Legend class

Win32::OLE(0.1707) error 0x80020009: "Exception occurred"
    in PROPERTYPUT "Position" at Processor.pl line 1043

    $mcr_crtime_chart->{HasLegend} = 1;
    $mcr_crtime_chart->Legend->{Position} = xlRight;

OLE exception from "Microsoft Office Excel":

...

Win32::OLE(0.1707) error 0x80020009: "Exception occurred"
    in PROPERTYPUT "Name" at Processor.pl line 1056

use OLE;
use Win32::OLE qw(in with);
...
    $Yaxes->{HasTitle} = 1;
    $Yaxes->{AxisTitle}->{Characters}->{Text} = "MCR (%)";