Hey guys,
Have a problem. A set of values have a cost for each month. They guys above me want to see this in chart form, but I don't want to have to alter the range of the chart each time I add a new month. Tried putting the data in a list, this updated the chart if a new costing team joined in a new row, but not for a new month in the next column. Any ideas?
Create named ranges for each team. For team1 for your example sheet the formula would be:
next for the data series values use the formula:
Please Login or Register to view this content.
I've attached the updated sheet.Please Login or Register to view this content.
Using the list as data source mean the chart will auto update when new teams are added. But adding new months will not. Plus adding new months changes the list size and breaks the link with the chart meaning new teams are not added.
Using named ranges will help with the expansion of months but a new named range will be needed each time a team is added.
If you base the chart on a range larger than the current data table you can hide the excess rows and columns and these will be omitted from the chart.
As soon as you unhide a row or colulmn the chart will auto update.
Of course hiding rows/columns presents another problem with regards to makeing user input easy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks