Hi guys,
I found a template online for a Vehicle Log (link below). It has a chart that display the cost of gas or maintenance (which are in two different tables) and updated based on the value you choose from a dropdown menu. Could someone please tell me how this is done? The sheet doesn't seem to have any macros.
https://templates.office.com/en-us/V...ook-TM04014212
Thank you!
The link doesn't work for me. Could you attach the workbook?
BSB
Vehicle log book.xlsx
Sorry for the hassle! I've attached the file here.
I see three "filtered lists" in your file, so I assume you are referring to the "autofilter" feature that is being used here. Here's one of many tutorials on the internet: http://www.contextures.com/xlautofilter01.html
Originally Posted by shg
Hi, the file has a drop down list (Cell N6). Based on whether you choose Gas or Maintenance, the chart below will change. How do you draw a chart that changes based on the selection?
Now I see your question. The spreadsheet appears to be using a a variation of "dynamic named ranges". Instead of the usual OFFSET() or INDIRECT() function, the sheet uses CHOOSE() formulas in the named formulas/ranges to specify which ranges to apply to the chart.
1) If you select the series and look in the formula bar, you should be able to see the names in the respective parts of the series definition. (ChartDates, ChartVals)
2) With a spreadsheet cell selected, you can go into the Name Manager (Formulas tab) and see the different names defined in the workbook.
3) If you have questions about how the CHOOSE() or other functions work, help files can be accessed in your Excel installation, or here (https://support.office.com/en-us/art...6-c6d90033e188 )
Thank you! Will look into it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks