1 graph for 2 product tables

Q

qureshi2016

New Member
Joined
Jan 7, 2016
Messages
8
Hi i have 2 tables of different product in both tables common factor is price and year but product type is different can you please support to create this in 1 graph i can do this in 2 graphs but i want both products in 1 graph.

Let say 1 product tv screen size average annual price 5 years(2016 to 2020) from 18'' 21" 24" 30"

2nd product car type as per speed 100mph 120 mph 125mph 150mph annual price with average for 5 years (2016 to 2020)

I need both products in 1 graph in excel.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
qureshi2016 said:
Hi i have 2 tables of different product in both tables common factor is price and year but product type is different can you please support to create this in 1 graph i can do this in 2 graphs but i want both products in 1 graph.

Let say 1 product tv screen size average annual price 5 years(2016 to 2020) from 18'' 21" 24" 30"

2nd product car type as per speed 100mph 120 mph 125mph 150mph annual price with average for 5 years (2016 to 2020)

I need both products in 1 graph in excel.
Click to expand...
 

Attachments

  • Capture.JPG
    Capture.JPG
    95.1 KB · Views: 4
Upvote 0
You must log in or register to reply here.

Similar threads

JenniferMurphy
  • Question
How to synchronize two tables?
Replies
0
Views
142
JenniferMurphy
JenniferMurphy
k3yn0t3
  • Solved
INDIRECT with INDEX(MATCH())?
2
Replies
10
Views
924
k3yn0t3
k3yn0t3
P
  • Question
Formula that checks 4 different parameters before giving a solution
Replies
4
Views
398
Legacy 143009
L
C
  • Question
Solar revenue calculator with dual cumulative/compounding factors
Replies
0
Views
295
CRHAAG
C
E
  • Question
Can anyone help me get my VBA code working? I have spent tons of time but can't quite fix it.
Replies
3
Views
2K
profray
P

Forum statistics

Threads
1,215,492
Messages
6,125,115
Members
449,206
Latest member
burgsrus

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top