How to create a dashboard

[ap1591]

Good afternoon,
I am trying to create a dashboard. I am trying to count the number of pending, open and closed by week, month and yearly by category and type.
I would also like to create a line graph. I would also like to create a slicer in the dashboard by category.

How can I start the dashboard and pivot tables within the dashboard.

Thank you!

[MarvinP]

Hi ap,

You need to have better data before you can do a dashboard. Fix your data and reattach it.

Improve your data table.xlsx

[ap1591]

I provided better data. I tried to start a pivot table but could not put pending open and closed as a row title.

Thank you.

[jeffreybrown]

Are you looking for something like this...

[ap1591]

Yes, but how do I put that information in a graph.

[jeffreybrown]

Build a pivot chart.

http://www.excel-easy.com/examples/pivot-chart.html

[ap1591]

I tried to follow the directions but two of the lines are not showing on my graph. I don't know what I am doing wrong.

[jeffreybrown]

Your other two lines are on the chart, it's simply all three lines are the same so only one shows.

I'm not sure you want a line chart.

[ap1591]

You are amazing! that is perfect. Thank you.