mohagany19
New Member
- Joined
- Jan 11, 2014
- Messages
- 2
Currently manually updating about 30 charts monthly. Adding new data monthly. Would like to make charts dynamic
I would like to use the offset function and named ranges. I can get as far as one dimension and one series but I am stuck as to how to use both series (revenue and volume). But I would like to continue using a combo chart (vol vs revenue) Set up is as follows. I get that I can use filters for the region, product, and customer.
DATE REGION PRODUCT CUSTOMER VOLUME REVENUE
1/15/2019 NORTH SHOES EXCEL 100 1000
1/30/2019 SOUTH SHIRTS ACCESS 500 750
Main questions
1. Best way to set up data? horizontal or vertical
2. Best way to format date so that it appears correctly in the graph
3. Data table or values best way to display date
4. and of course, OFFSET functions in the chart data source area.
Thank you in advance
I would like to use the offset function and named ranges. I can get as far as one dimension and one series but I am stuck as to how to use both series (revenue and volume). But I would like to continue using a combo chart (vol vs revenue) Set up is as follows. I get that I can use filters for the region, product, and customer.
DATE REGION PRODUCT CUSTOMER VOLUME REVENUE
1/15/2019 NORTH SHOES EXCEL 100 1000
1/30/2019 SOUTH SHIRTS ACCESS 500 750
Main questions
1. Best way to set up data? horizontal or vertical
2. Best way to format date so that it appears correctly in the graph
3. Data table or values best way to display date
4. and of course, OFFSET functions in the chart data source area.
Thank you in advance
