Simple Charting Question

[vgarcia620]

Hello,

I've created a spreadsheet to help me with recruiting, however on the spreadsheet I attached I can't figure out how to make the chart do the following:

Total Positions Open: 50
Total Positions Filled: 0
Total positions Unfilled 50

Where it says positions open 50 or whatever # is there, that should show on the chart as 100 and positions unfilled should show as 0 if all 50 positions are still open. Then positions open should show the percentage of whatever both are.

I'm hoping this makes sense, you probably would have to open my sheet to see what I'm talking about.

Your help is greatly appreciated.

[teylyn]

Hello,

You're doubling up the positions by charting all three cells. You only need two data points in the chart: filled and unfilled. Remove the "open" from the chart.

cheers, teylyn

[vgarcia620]

Lol, well that was easy. Thanks!