M
Mike.Schires
I have sales data with multiple columns for different products, which
has many rows for data each month. I want a quick and easy way to
create a dashboard that shows current month sales, quarterly sales,
both of these compared to last year monthly and quarterly results, and
I want it to be dynamic.
I thought a List would be my ticket, as I can create a list from the
data, plot product sales in each product category, and use a filter to
show the month or quarter or year, but it seems I can only do one at a
time. To do a dashboard, I want all charts to show up at once, have a
filter that does monthly and another that does quarterly. Seems I'd
have to have duplicate lists of data with individual filters on each.
That is a lot of data and seems very inefficient.
I then started using named ranges with OFFSET, and this seemed to get
messy really fast with all the different product data I need to
crunch.
Any ideas? I'm using Excel 2003.
has many rows for data each month. I want a quick and easy way to
create a dashboard that shows current month sales, quarterly sales,
both of these compared to last year monthly and quarterly results, and
I want it to be dynamic.
I thought a List would be my ticket, as I can create a list from the
data, plot product sales in each product category, and use a filter to
show the month or quarter or year, but it seems I can only do one at a
time. To do a dashboard, I want all charts to show up at once, have a
filter that does monthly and another that does quarterly. Seems I'd
have to have duplicate lists of data with individual filters on each.
That is a lot of data and seems very inefficient.
I then started using named ranges with OFFSET, and this seemed to get
messy really fast with all the different product data I need to
crunch.
Any ideas? I'm using Excel 2003.