I am looking to take some Excel charts & make them interactive.
In example, I have two data sets in a pie chart (one data set for Bill & one for Sally) that measures % of total household income each of them brings home. I also have a bar chart on the same worksheet that has the same two data sets (Bill & Sally), but the bar chart measures years of experience. I would want something that when you select Bill's data series in the pie chart, the bar chart would automatically refresh to only show Bill's data. Kind of along the lines of Microsoft 2013 Power View, but this code would need to work for embedded charts in Excel 2010.
Ideally - I would like 'generic' VBA code or a Macro so that I can copy the code to any workbook and have the same functionality. I would imagine this would probably have to be done with Chart Events in VBA. I am fine with having to edit SOME code attributes (i.e. changing chart names in the code) to make this work. As you can tell - I am a VBA programming novice that has a basic understanding of VBA, but nothing to this extent.
I would like this done as soon as possible, but there is not a set deadline. I would like this to stay a small project & budget friendly if possible.
Please reach out with any questions & I look forward to working with whomever!
12 freelancer bu iş için ortalamada 136$ teklif veriyor
I have developed many many macros for Finance Department in various versions of Excel starting from Excel 4 to Excel 2010. If interested, please contact.