How to Use Wps AI/Chatgpt to Generate Charts A Comprehensive Guide for Beginners

August 1, 2023 2.5K views

Excel, a formidable tool for data calculation and organization, offers great efficiency in generating charts. However, navigating the complexity of formulas and data can be daunting. A common question arises: "How can I streamline chart generation and save time?" The solution is Excel AI, which allows users to easily build charts suited to their data needs without the stress of complex formulae and graphs.

Part 1: How to Use WPS AI to Generate Charts

WPS AI is a powerful AI-powered assistant that can help you with a variety of tasks in Excel, including generating charts. WPS AI uses artificial intelligence to understand your data and automatically generate the most appropriate chart for your needs. This means that you no longer have to worry about learning how to use complex formulas or manually creating charts.


Step 1: Access WPS AI

Step 2:  Open WPS Sheet

Step 3: Import Data

Import your dataset into WPS AI for chart generation

Step 4: Get suggested visualizations

After selecting your data, simply right-click on it, and from the menu, choose "Chart”.

We'll immediately show you some AI-recommended graphics.

Step 5: Customize Chart Settings

Customize the chart by adding labels, titles, and other design elements.

Advantages of WPS AI for Chart Generation:

  • Intuitive Interface: WPS AI offers a user-friendly interface, making chart generation hassle-free for all users.

  • Swift Processing: With its powerful AI capabilities, WPS AI processes data and creates charts quickly and efficiently.

  • Customization Options: Tailor charts to your specific requirements by customizing colors, labels, and other chart elements.

  • Time-Saving: Utilize WPS AI's efficiency to save time and focus on other essential tasks.

How to download WPS AI

Step 1 Visit WPS AI website

Step 2 Users will be requested to join up in order to have early access to WPS AI.

Step 3 To register for early access, users must fill out the registration form.

Step 4 After approval, customers will get an email from WPS AI with instructions on how to download and install WPS AI on their systems.

After the installation is complete, customers may open WPS AI on their systems and take use of the numerous functions it provides.



WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User


Algirdas Jasaitis

Part 2: How to Use ChatGpt to Generate Charts

Step 1 Install the 'Wolfram' and 'Show Me Diagrams' ChatGPT Plugins first.

To make graphs and charts, you'll need a combination of ChatGPT plugins.

Step 2  Open a new conversation and select the 'GPT-4' option.

Navigate to the 'Plugin Store'.

Step 3 Look for and install the Wolfram and Show Me Diagrams plugins.

Step 4  Request that ChatGPT visualize data.

In your prompt, instruct ChatGPT to construct a graph, diagram, or chart to illustrate your data using the Wolfram and Show Me Diagrams plugins.

Prompt: Create two pie charts using the 'Show Me Diagrams' plugin.

I want the pie charts to illustrate how much each product and area contribute to overall income or units sold.

Here are the sales information

Here are the results:

ChatGpt Prompts:

  • Write a Script: Provide a brief summary of the plot for a play or movie, and ChatGPT will generate the script for you, bringing your story to life on the page.

  • Write a Chatbot: Describe the chatbot you want, including its personality, purpose, and interactions. ChatGPT will generate a natural and engaging chatbot that can interact with users according to your specifications.

  • Write a Thesis: Give a brief summary of the topic you want to explore, and ChatGPT will generate a well-structured and comprehensive thesis on that subject.

  • Write a Dissertation: Provide a brief overview of the topic you wish to delve into, and ChatGPT will create a detailed and extensive dissertation, showcasing in-depth research and analysis.

  • Add Creativity to Pre-Written Content: Share your existing text, and ChatGPT will enhance it by adding new ideas, phrases, and vivid imagery to make it more engaging and interesting.

  • Simplify: If you have complex or lengthy text that needs to be more concise and straightforward, share it with ChatGPT, and it will simplify it while retaining its essence.

Part 3: What is Excel AI

Excel, a powerful tool that has been assisting users in data manipulation and analysis for decades, has adapted and evolved with technological advancements. The addition of Artificial Intelligence (AI) features has transformed how users interact with data in Excel, allowing them to do more complicated data analysis and acquire useful insights with higher efficiency.

There are a number of Excel AI tools available, including:

  • Excelly-Ai is an AI-powered Excel add-in that can help you with tasks such as data cleaning, data analysis, and data visualization. It can also generate Excel formulas based on your natural language instructions.

  • GPTExcel is a GPT-3 powered Excel add-in that can help you with tasks such as writing formulas, creating reports, and automating tasks. It can also generate Excel formulas based on your natural language instructions.

  • WPS AI: WPS Office, an alternative office suite to Microsoft Office, includes AI-powered capabilities in its spreadsheet application. Users can harness intelligent data analysis, benefit from smart charts, and leverage AI-generated pivot tables.

Benefits of AI Tools for Excel:

  • Automated Tasks: AI tools automate repetitive tasks like data entry and analysis, saving time and improving accuracy.

  • Advanced Data Analysis: AI algorithms analyze large datasets, finding patterns and anomalies not easily seen manually.

  • Dynamic Graphics: AI enhances data visualization, making it easier to understand complex information.

  • Deeper Insights: AI helps users gain a better understanding of their data.

  • Increased Productivity: AI-powered automation optimizes processes, saving time and boosting productivity in Excel.


1. Is ChatGPT free?

ChatGPT is available for free with a free OpenAI account. However, there may be options to upgrade to a paid membership for more extensive usage or advanced features in the future.

2. Can AI-generated charts be customized?

Yes, AI-generated charts can be customized according to your preferences. You can modify colors, labels, axis scales, and other elements to suit your specific data visualization needs.

3. Are the AI-generated charts accurate?

AI-generated charts are generally accurate, as they are based on the data provided and the algorithms used. However, it is essential to review and validate the data before drawing conclusions from the generated charts.


In conclusion, this comprehensive guide has highlighted the benefits of AI tools for Excel, focusing on the exceptional capabilities of WPS AI. The integration of AI in Excel has significantly enhanced data analysis processes, enabling users to generate charts effortlessly, save time, and make more informed decisions.

WPS AI stands out as a powerful AI-powered assistant that revolutionizes chart generation in Excel. Its intuitive interface, swift processing, customization options, and time-saving efficiency make it an invaluable tool for both beginners and experienced users.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.