Choose source for data in excel chart

BLuse

New Member
Joined
Apr 15, 2016
Messages
11
How do I choose the source for labels and data for a chart in excel?

What I want the chart to show is the label on the left to show Item name, then a line to track the sales month over month and the month and the bottom label to show the corresponding month. Also, if possible add another 'dashed' line to show the unit count month over month.

My data:
ItemDataDataDec SalesJan SalesFeb SalesMar Sales
Units SalesUnits SalesUnits SalesUnits Sales
Apples****5$107$14$6$128$16
Oranges****2$64$125$153$9
Plums****
Bananas****

<tbody>
</tbody>
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

jjasmith4

Board Regular
Joined
Aug 22, 2018
Messages
58
Seems best to have an XY chart with a secondary axis. First, though, you can't have more than one row or column for labels, so change "Units" and "Sales" to something like "Dec #"/"Dec $", "Jan #/Jan $", etc. Then select a range from the cell just above Apples, even if it's blank, to March's banana sales, then insert the XY chart that has lines and markers.


Next, if you have only four legend labels which are the fruits, you have to switch categories and series: right-click the chart, choose Select Data, and click the Switch button so the fruits are on the right (categories). Then your legend will have all the months' #/$ numbers, eight in all.


The next step is to plot all the "$" data on a secondary axis, which doesn't exist yet. Click the chart, then on the ribbon's Chart Tools section click Format. Use the dropdown way at the upper left to change "Chart Area" to "Series Dec $", then click the Format Selection tool under it, and on Series Options choose Secondary Axis. Repeat this for all the "Series ... $" entries.


Now you can continue to change the dropdown and click Format Selection to do anything you want: labels, dashes, etc.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,826
Messages
5,855,875
Members
431,771
Latest member
CoryMelth

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
Top