How do I make a chart with multiple data points?

[ajeffres]

I have multiple data points I'm wanting to create into a chart. My data includes number of immunizations given to age groups between 1 and 18 (<1, 1-6, 7-18). Then I also want to display what profile they fit into so for instance I have 2 patients <1 who were Medicaid, 3 patients 1-6 who were Insured, 10 patients 7-18 who were Uninsured. Then...I want to show this in the differences between years, 2013-2018. Help GREATLY appreciated!

[MrShorty]

I find that a lot of charting questions are really spreadsheet questions. It is not clear to me exactly what you need to do. As a guess, if I assume that you have a nice database of information to start from, then this looks like a pivot table/pivot chart type of problem. Use a pivot table to summarize your data, then visualize the pivot table in a suitable bpivot chart.

Your profile indicates that you are using Excel 2003. A couple of basic tutorials for pivot tables/charts in earlier versions of Excel:
https://www.techonthenet.com/excel/pivottbls/create.php
http://www.excelfunctions.net/Create...xcel-2003.html

Beyond something generic like that, I'm not sure we can be much help without a better idea of how your data is stored in the spreadsheet, exactly what data you want to chart, how you intend to calculate the data for the chart, the type of chart you want to use, and such like that.