Hi,

I am trying to create a column chart (if that's my best option) for a 12 month trend. I have a total number (in the 3,000s) and I want my smaller number (in the 600-800) that shows as "part" of the total. Basically I want one column for the total, and then I want to show how much of that total is made up of my smaller number.

On top of that, I need a trend line that shows what % the smaller number is of the total number. On top of that I need a 2nd trend line with percentages from the previous year.

Here is my data:

Visits (total)
admits (part of the total)
admits %

Can someone help me, please?