İptal Edildi

VBA Chart Events Interactive Functionality

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!

As mentioned above, Microsoft has something similar with Power View in 2013, but it has many drawbacks that wont work for me. Nevertheless, here is a video I found that gives a general idea of what I'm looking to do in the graphs in Excel 2010: http://www.youtube.com/watch?v=zjLoPg76uRg .

Just to clarify - the example listed above with Sally & Bill is a very simplified version of what I am trying to achieve. I will have 3-5 graphs in any given worksheet that will need to interact with each other & the graphs could be a combination of pie charts, bar charts, or line charts. The graphs will need to all be linked with each other (in example, chart one can control chart two and chart three, chart three can control chart one and chart two, ect). Also, there could be a varying number of series in the chart - some may have 3 series of data in the graph and some may have 20. Again - I urge you to watch the YouTube video link above as that is essentially what I want in an Excel 2010 file.

I'll reiterate this again - the biggest 'want' with this project is that I can take what you create & I can apply the code into different workbooks to make them interactive as well with little modification.

I thought I was clear originally in the post, but possibly not. Please adjust your bid accordingly.

Thanks again & sorry for any confusion. Please reach out with any questions & I truly do look forward to working with you!!!

Beceriler: Excel, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: excel vba interactive chart, excel vba chart events, excel 2010 vba chart events, vba code charts interactive, vba programming in excel, vba excel programming, take two interactive, take - two interactive, programming in visual basic 2010, programming in vba, programming in excel vba, programming in excel 2013, programming in excel 2010, programming events, power programming with vba, microsoft excel vba programming, make a chart, macro programming in excel, generic excel, excel vba macro programming, excel programming vba, microsoft vba, microsoft excel VBA, in vba, excel 2013 vba

İşveren Hakkında:
( 6 değerlendirme ) PLANO, United States

Proje NO: #4430316

Bu iş için 12 freelancer ortalamada $136 teklif veriyor


I can help, I have developed many dynamic charting applications.

in %bids___i_period_sub_35% gün içinde120%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)

Consider it done. Check your PM for my bid details.

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(51 Değerlendirme)

Hi, I can do it. I'm a programmer for years and very familiar with VBA. Does this what you need? 1/ two data set to draw 1st chart (any kind) 2/ user select a data series of the 1st chart the 2nd chart will updated: Daha Fazla

in %bids___i_period_sub_35% gün içinde99%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(27 Değerlendirme)

Hello! Let me propose you all the best of my experience in VBA for excel programming! Thank you! Denis Smolentsev

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(46 Değerlendirme)

More than 10 years experience in Excel and VBA.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)

This can be done easily.

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)

Expert VBA programmer

in %bids___i_period_sub_35% gün içinde84%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hi - Excel VBA expert and teach the same. I build robust solutions. Period. My pedigree in your PM. SteveP.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Hi - Excel/VBA expert [login to view URL] check PM for details.

in %bids___i_period_sub_35% gün içinde110%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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.

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

7 years Excel VBA Front-Office bespoke spreadsheet developer.

in %bids___i_period_sub_35% gün içinde69%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

6 years of experience with VBA. I'll try to make the code as generic as possible.

in %bids___i_period_sub_35% gün içinde59%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

jpd, Ineresting assignment. Sending you an "interactive" graph in Excel 2010 that will enable you to judge for yourself whether I can deliver what you want. Happy to work under a Confidentiality and Non-Disclosur Daha Fazla

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)