Choose source for data in excel chart

BLuse

New Member
Joined
Apr 15, 2016
Messages
9
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>
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

jjasmith4

New Member
Joined
Aug 22, 2018
Messages
48
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,790
Messages
5,524,893
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top