Hi,
You can use the default Chart display which is provided by SAP when you execute the Workbook in Analyzer. This Chart option is able to pick the data dynamically from the workbook. This is achieved by Macro work.
However if the Data is static (basically the number of rows in the output is fixed) you can also use Excel Chart options as this provides more chart options.
Thanks & Regards,
NM
Thank you Namrata for your reply. Do you have any material for creating graphs and tables using Macro in an Analyzer workbook.
My scenario here is, I have data which comes from BI query on my workbook. Then I should have a summarized table from which I should create a graph. Do you have any relevant material or suggestions for this?
Thanks
Hi,
I don't have any materials on hand. You might find in SDN. If the format of the summarized Table is fixed I would suggest, building a summarized BI Query and creating a graph based on Excel functions.
Thanks & Regards
Namrata
Hi Namrata,
The actual table, the summarized table and the graph should be in the same page of workbook.
Thanks
