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

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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
108
JenniferMurphy
JenniferMurphy
k3yn0t3
  • Solved
INDIRECT with INDEX(MATCH())?
2
Replies
10
Views
879
k3yn0t3
k3yn0t3
P
  • Question
Formula that checks 4 different parameters before giving a solution
Replies
4
Views
394
Legacy 143009
L
C
  • Question
Solar revenue calculator with dual cumulative/compounding factors
Replies
0
Views
293
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,016
Messages
6,122,700
Members
449,092
Latest member
snoom82

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