Excel Visual Chart

BLuse

New Member
Joined
Apr 15, 2016
Messages
13
Hi,

I'm looking for help designing a chart to show a sales chart along different data sets. I want the chart to show Sales, Profits, from two different revenue stream and for each time period. How can I design a chart to show all the data in one chart?

ItemSalesProfitsSalesProfitsSalesProfitsSalesProfitsSalesProfitsSalesProfits
AprAprMayMayJunJunJulJulAugAugSepSep
eBayApples
1500​
750​
1800​
900​
1200​
600​
1000​
500​
1400​
700​
1300​
650​
eBayOranges
450​
225​
540​
270​
360​
180​
300​
150​
420​
210​
390​
195​
AmazonApples
3750​
1875​
4500​
2250​
3000​
1500​
2500​
1250​
3500​
1750​
3250​
1625​
AmazonOranges
1125​
562.5​
1350​
675​
900​
450​
750​
375​
1050​
525​
975​
487.5​
 

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 do not specify what kind of chart you want, but IMHO anything you decide to create, you would be much better off storing your data in a different format. For example if you stored it like shown below you would be in a much better position to sort, and slice/dice the data to create better visuals, including pivot tables.

Book1
ABCDE
1ITEMMONTHVENDORSALESPROFITS
2APPLESAPRILEBAY1500750
3APPLESMAYEBAY1800900
4APPLESJUNEBAY1200600
5APPLESJULEBAY1000500
6APPLESAUGEBAY1400700
7APPLESSEPEBAY1300650
8ORANGESAPRILEBAY450225
9ORANGESMAYEBAY540270
10ORANGESJUNEBAY360180
11ORANGESJULEBAY300150
12ORANGESAUGEBAY420210
13ORANGESSEPEBAY390195
14APPLESAPRILAMAZON37501875
15APPLESMAYAMAZON45002250
16APPLESJUNAMAZON30001500
17APPLESJULAMAZON25001250
18APPLESAUGAMAZON35001750
19APPLESSEPAMAZON32501625
20ORANGESAPRILAMAZON1125562.5
21ORANGESMAYAMAZON1350675
22ORANGESJUNAMAZON900450
23ORANGESJULAMAZON750375
24ORANGESAUGAMAZON1050525
25ORANGESSEPAMAZON975478.5
Sheet1
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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