OraFAQ Forum: Forms » Excel Charts. How to set title and labels

Home » Developer & Programmer » Forms » Excel Charts. How to set title and labels (Forms 10g, Windows 7 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Excel Charts. How to set title and labels [message #550882]

Fri, 13 April 2012 04:07

calacausi
Messages: 23
Registered: March 2012

Junior Member

hi,
im still trying to create workcharts into an Excel sheet (see thread "How to create pie chart in Excel sheet"). I could not be able to create pie chart, but I got to create a histogram chart. Now, I wish to customize labels and legend.
The issue is that the data range is made by non-contigouous cells, and some of them are merged. So, I tried to create by hand a pie chart, and this is the code behind:

Sub Macro1()
'
' Macro1 Macro
'

'
    Sheets("SUMMARY COSTS 2011-2012-2026").Select
    Range("D11,F11").Select
    Range("F11").Activate
    ActiveSheet.Shapes.AddChart.Select
    ActiveChart.ChartType = xl3DPieExploded
    ActiveChart.SetSourceData Source:=Range( _
        "'SUMMARY COSTS 2011-2012-2026'!$D$11;'SUMMARY COSTS 2011-2012-2026'!$F$11")
    ActiveChart.SeriesCollection(1).Name = "=""SUMMARY"""
    ActiveChart.SeriesCollection(1).XValues = _
        "='SUMMARY COSTS 2011-2012-2026'!$C$4;'SUMMARY COSTS 2011-2012-2026'!$E$4"
    Application.Goto Reference:="Macro1"
End Sub

how can I implement this code in Forms 10g using OLE2? In details, how does SeriesCollection work? Thanks for your help

Attachment: step2.jpg
(Size: 213.95KB, Downloaded 750 times)

Report message to a moderator

Re: Excel Charts. How to set title and labels [message #550957 is a reply to message #550882]

Fri, 13 April 2012 16:26

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

You can create pie chart in excel sheet by using ole2 use your skills
and of other option

http://www.oracle.com/technetwork/articles/marx-jchart-085298.html

regards
baba

[Updated on: Fri, 13 April 2012 16:28]

Report message to a moderator

Re: Excel Charts. How to set title and labels [message #551204 is a reply to message #550957]

Mon, 16 April 2012 05:06

calacausi
Messages: 23
Registered: March 2012

Junior Member

owais_baba wrote on Fri, 13 April 2012 23:26

You can create pie chart in excel sheet by using ole2 use your skills
and of other option

http://www.oracle.com/technetwork/articles/marx-jchart-085298.html

hi baba,
it seems that jfree creates a piechart into an Oracle Form. How can I embed it in my Excel sheet?

Report message to a moderator

Re: Excel Charts. How to set title and labels [message #551241 is a reply to message #551204]

Mon, 16 April 2012 10:03

calacausi
Messages: 23
Registered: March 2012

Junior Member

as I suspected, there is no need to attach external tools to create a pie chart. OLE2, with appropriate parameters (the hard thing was to find them...) suffices.
impossible is (almost) nothing! ahah

Report message to a moderator

Previous Topic:	two database list item
Next Topic:	LOV , autoselect values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 29 08:10:34 CDT 2024