Creating a chart using a table made of 4 columns, but only using 3 of the columns.

**Excel-newbie-in-need** · 05-27-2022, 10:05 AM

I have an excel table that has to transitioned in a chart, the table contains 4 columns. I am not allowed to modify this said table in any way.
I need to create a chart for it, but the chart has to contain only the content from 3 of the columns.

How do I create such a chart? Since I cannot select the table itself, since it contains unwanted data...

Thank you for your interest and assistance!

A B C D
1 Produce Sold Ordered Left
2 Apples 100 100 0
3 Bananas 90 100 10
4 Watermelons 80 100 20

I only need to use what was sold and what is left for the chart.

EDIT: This was a non-sensical question regarding a chart

**Excel-newbie-in-need** · 05-27-2022, 10:10 AM

Sorry for not including a work-sheet, I do not have the file in front of me at the moment

**AliGW** · 05-27-2022, 10:53 AM

Please share the solution and mark the thread as solved.

Do NOT post-edit your posts in this destructive way in future, please.

Creating a chart using a table made of 4 columns, but only using 3 of the columns.

LinkBack

Thread Tools

Rate This Thread

Display

Creating a chart using a table made of 4 columns, but only using 3 of the columns.

Re: Creating a chart using a table made of 4 columns, but only using 3 of the columns.

Re: Creating a chart using a table made of 4 columns, but only using 3 of the columns.

Thread Information

Users Browsing this Thread

Similar Threads

choosing what columns from pivot table show on chart without removing columns from table

[SOLVED] Filling Listbox with more than 10 columns with array made from table with hidden columns

Creating a Chart from select columns/rows in a Pivot Table

Creating a Chart - Linked with 3 Columns

creating a chart with x-coordinates in different columns

[SOLVED] Creating a Macro to Chart two columns

Skip some columns when creating a chart

Bookmarks

Bookmarks

Posting Permissions