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,
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?