How to make a churn report/chart (2003)

[MelanieB]

One of my coworkers wants to create a chart that shows churn of subscribers to our fiber system.
She hand drew what she wants, and it looks like a stacked bar chart with a line graph across it.
The stacked bar would show the existing suscribers on bottom and the new subscribers on top and the line would represent the dropped subscribers.
She has data and I can send a sample if someone could help me figure it out.

Anyone game to help me with this?

[HansV]

That sounds like a combination chart. You can set up the chart as a stacked bar chart with 3 series, then select the series of dropped subscribers and change its chart type to a line chart.

It you would like more specific help, it'd be nice to have a sample workbook, and perhaps a scan of the drawing.

[MelanieB]

Thanks Hans that helped. I showed her a bar chart with a line graph - 3 series. She said that works fine.