Excel graph with 2 legends

L

Legacy 386498

Guest
Hi all,

I want to create a graph based on years (2017, 2018 and 2019), companies (A1, A2 and A3) and type of product (cake, chocolate and cookie). I know it's possible to create a graph based on 2 of these, but it is possible to based one on all of them? If so, how should I setup my data?

Thanks.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
You must log in or register to reply here.

Similar threads

T
  • Question Question
Help with Calculating Median per Group per Year
Replies
1
Views
122
Kaper
Kaper
B
  • Question Question
Find Top 10 customers based on sales columns
2
Replies
10
Views
279
etaf
etaf
N
  • Question Question
Pivot graph data when creating a new tab from a template.
Replies
0
Views
276
Nippyzap
N
J
  • Question Question
There must be something simpler to do this kind of graphing....
Replies
0
Views
297
juanjoge
J
N
  • Question Question
Dashboards
Replies
1
Views
364
awoohaw
awoohaw

Forum statistics

Threads
1,225,730
Messages
6,186,698
Members
453,369
Latest member
positivemind

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