IBM Mainframe Forum

Hi,
I would like to generate the chart( pie chart ) for the data I have using REXX.
The chart can be create in any of the following (excel, Msword)
Please help me out to solve this scenario.

It is not clear to me what you are asking for. Neither Excel nor MS Word work on z/OS. Are you asking to create a file on z/OS, download it to Windows, then have it display a pie chart?

REXX is a Turing-complete language. It can do anything you want. Just decode the internal format of charts in Excel and Vijaj is your uncle!

Just decode the internal format of charts in Excel and Vijaj is your uncle!

The Microsoft Excel Binary File Format Structure document is 1124 pages in version 4.2, so you might need a little time to do what you want.

Pedro wrote:It is not clear to me what you are asking for. Neither Excel nor MS Word work on z/OS. Are you asking to create a file on z/OS, download it to Windows, then have it display a pie chart?

Thanks for your reply

My actual question is, how to create a pie chart using Rexx coding
And I want to display that generated pie chat in ( Ms word or Excel)..Is this possible??

SKANDA wrote:My actual question is, how to create a pie chart using Rexx coding

You could probably create a text "pie" chart using Rexx, though I think you would find it rather difficult.

SKANDA wrote:And I want to display that generated pie chat in ( Ms word or Excel)..Is this possible??

If you created the chart, it would be rather easy to create a text data set, send the data set to a Windoze work station and load it into M$ Word.

All in all, you'd be better off shipping the data to a Windoze work station in a CSV formatted data set data set, loading the data set into Excel or something similar, and using Excel to create the "pie" chart. In 2002 through 2006 I was involved in a project to extract SMF data and use Excel to make pretty charts from the data.

thank you steve,
As of now my REXX code will perform some calculation and export the output result to the csv file.so now I want to create a pie chart for those output data which is in csv file. And also could you pls give any sample code ? to resolve this task.

Moderators, please close this thread!

The TS is obviously totally clueless and continues to run in circles!

sorry for the inconvenience prino,
pls try to understand my question and give some solution,,,..
is there any rexx syntax or rexx code to create pie chart in excel...

many thanks,
SKANDA.

is there any rexx syntax or rexx code to create pie chart in excel...

NOT on the mainframe

as already told,
1 -create a csv file ( using REXX or whatever other language of Your choice )
2 - download it to the windows workstation
3 - import it into an EXCEL spreadsheet
4 - create the graphic in any format supported.

but You might find interesting
http://www.rexxinfo.org/html/rexxinfo1. ... exx-HowTos

but still You will have to run step 1 on the mainframe
after that You might be able to automate ( using ooRexx on Your Windoze )
steps 2, 3 and 4

anyway topic locked to prevent further noise