Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^3: Excel and Win32::OLE chart problems

by bmann (Priest)
on Oct 30, 2007 at 20:08 UTC ( #648101=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Excel and Win32::OLE chart problems
in thread Excel and Win32::OLE chart problems

If I understand your question correctly, the values in B5-B12 should be the XAxis labels, right?

If so, use that range as the source data for the chart, ie

$chart->Chart->ChartWizard({Source => $sheet->Range("B5:B12,D5:D12")};
instead of just D5:D12. I believe that the two SeriesCollection lines are the defaults, so they shouldn't be necessary. Keep the ColorIndex line though.


Comment on Re^3: Excel and Win32::OLE chart problems
Select or Download Code
Replies are listed 'Best First'.
Re^4: Excel and Win32::OLE chart problems
by the_hawk_1 (Scribe) on Oct 30, 2007 at 21:36 UTC
    Sorry to give you such a bad news, but now I've moved backwards: I've lost all the data in the chart! Is it possible to avoid the chartWizard?!?

    Update:It works! we just need a ; instead of a , in the range line.

      I am having a similar problem. I need to add multiple series to one chart and so I don't believe I can use the ChartWizard.

      Currently, I use the following code to add a series:
      $Chart->SeriesCollection->Add($Sheet3->Range("D$num2:D$num1"));

      This however does not set the XValues, which I try to do with the following code:
      $Range = $Sheet3->Range("C$num2:C$num1");
      $Chart->SeriesCollection($series)->XValues($Range); ;

      This results in the following error:
      Win32::OLE(0.1709) error 0x80020011: "Does not support a collection"
      in METHOD/PROPERTYGET "XValues" at ./PollenAVG.pl line 149

      Any Ideas? Thank you in advance.
      gr8 acticle guys, $chart->Chart->{ChartType} = xl3DColumnClustered; in this snippet whre can i find the list of all chartypes supported ? thanx

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://648101]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (11)
As of 2015-07-31 07:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (275 votes), past polls