How to create charts and excel files using ChatGPT. How to use ChatGPT to create excel files.

In this video I show you how to quickly generate charts and excel files using ChatGPT. Here are the prompts I used to assist me with this:
In a retail analysis report, sales figures across various product categories were examined. The data revealed that Electronics accounted for the highest sales, totaling $350,000. Following closely behind, Clothing sales amounted to $200,000, while Home Appliances and Books sales stood at $180,000 and $150,000 respectively. Toys and Sports Equipment recorded sales of $120,000 and $100,000 respectively. This data illustrates the distribution of sales among different product categories, providing valuable insights for strategic decision-making within the retail business.
please use python pandas to create an excel document based off of this data - please generate this file and output it in a file called sample_data.xlsx
please style the data in a pie chart - and add styling
#howto #tutorial #excel #exceltips #ai #chatgpt #charts #piecharts #piechart #gpt4 #python #pythonpandas