Page 1 of 2

is it possible to create chart using REXX

PostPosted: Thu Aug 04, 2016 7:58 pm
by SKANDA
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.

Re: is it possible to create chart using REXX

PostPosted: Thu Aug 04, 2016 9:26 pm
by Pedro
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?

Re: is it possible to create chart using REXX

PostPosted: Fri Aug 05, 2016 1:52 am
by prino
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!

Re: is it possible to create chart using REXX

PostPosted: Fri Aug 05, 2016 2:56 am
by Robert Sample
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.

Re: is it possible to create chart using REXX

PostPosted: Fri Aug 05, 2016 9:44 am
by SKANDA
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??

Re: is it possible to create chart using REXX

PostPosted: Fri Aug 05, 2016 12:30 pm
by steve-myers
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.

Re: is it possible to create chart using REXX

PostPosted: Fri Aug 05, 2016 3:53 pm
by SKANDA
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.

Re: is it possible to create chart using REXX

PostPosted: Fri Aug 05, 2016 4:48 pm
by prino
Moderators, please close this thread!

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

Re: is it possible to create chart using REXX

PostPosted: Fri Aug 05, 2016 6:05 pm
by SKANDA
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.

Re: is it possible to create chart using REXX

PostPosted: Fri Aug 05, 2016 6:25 pm
by enrico-sorichetti
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