Need help with a chart in Excel 2007...?
I have a spreadsheet that has 2 months (Jan and Feb) on it of a list of office supplies, cost/unit, number of units, total cost, and % of grand total. The only difference in the two months is that the Office supplies is listed once (Column A), the other columns listed for each month. I need to chart the office supplies items, and the total cost for each month. I have tried every way i know to pull out just the columns needed and cannot get it to graph correctly. Can someone please help? I have searched Excel help to no avail.........