Sharing Dashboad

I have created a bot which will query an excel and answer questions, now if the user wants to ask for visual graph, how do I send the visual chart created in the file as the response?

What kind of data format does the chart have? Is it a picture? Or maybe you can simply send a link to the chart?

For a start lets assume that its a pie chart, for example user asks how many male vs female patients for last month, we will create this pie chart during run time and then need to send it

I guess, the easiest way would be that your custom action builds this pie chart and creates a link to it, e.g. to the pie chart uploaded somewhere.

If you want to send the image of the pie chart directly, you would need to use an image or even use a a custom output payload.