Find Jobs
Hire Freelancers

excel - update line chart based on selections

$14-20 NZD

Tamamlandı
İlan edilme: yaklaşık 5 yıl önce

$14-20 NZD

Teslimde ödenir
i have an excel file with customer codes and sales values. There are 'n' customers (say 5,000), and each customer has sales values for 12 periods (in the example). I would like to graph each customer's sales in the period in a line chart. I would like the line chart to update each time i select a customer. for example, if I select customer 123, then that customers sales are graphed. If I select customer 456, then that customer's sales are graphed. This is is a sample of what I'm trying to do. If successful, there is a larger project based on the above principles. Sample file is attached. If you want to do this project please send back either a simple working example for the project, or provide some background on how you'd solve it.
Proje No: 18759519

Proje hakkında

12 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 5 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
Not a difficult project. I would add a dropdown box where the customer number is selected. Using that number as the key the apropriate row is selected to be displayed on the chart. I have actually done it already. It took me 2 minutes. I can send it to you for free if you allocate to me some other project. MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
$20 NZD 0 gün içinde
5,0 (37 değerlendirme)
5,0
5,0
12 freelancers are bidding on average $21 NZD for this job
Kullanıcı Avatarı
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
$20 NZD 1 gün içinde
5,0 (189 değerlendirme)
6,7
6,7
Kullanıcı Avatarı
Hello client I can do this for you. Please contact me. Roy ........................................................
$20 NZD 0 gün içinde
4,9 (360 değerlendirme)
6,9
6,9
Kullanıcı Avatarı
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$20 NZD 0 gün içinde
4,9 (32 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
Hello, i can finish this job in few hours i will write VBA code that fire when the selected row is changed then the data of the new row will be passed as input to the chart samples of my VBA work : https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ waiting your answer Thank you
$19 NZD 0 gün içinde
4,9 (62 değerlendirme)
4,6
4,6
Kullanıcı Avatarı
There is a very simple way to do this, in my opinion I would use a dropdown box with the names of all the customers that would output the charts you wanted just to make it simpler, that way you could add an autocomplete within the dropbox(sort of like google) and make the searching easier and even it would look even more professional. If you're interested feel free to message me. I can also teach you how to do it so you have it if you ever need it again.
$20 NZD 1 gün içinde
5,0 (14 değerlendirme)
3,8
3,8
Kullanıcı Avatarı
Good at excel analysis for DATA. I can have the work done within a few hours so as to get the count done correctly. I hope to hear from you soon, It would be nice
$23 NZD 0 gün içinde
4,6 (12 değerlendirme)
3,7
3,7
Kullanıcı Avatarı
Hi There, I am intrested in your project and would like to work on this, I have created and added one sample for the same by making a chart check box. Please review and let me know if you like the idea. Regards, Harmohit
$20 NZD 1 gün içinde
5,0 (1 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
A pivot chart is an easy option to solve your needs. I will create 1 page I struction manual (included in the price). I have 14 years experience in Excel.
$20 NZD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   AUSTRALIA bayrağı
Pagewood, Australia
4,9
14
Ödeme yöntemi onaylandı
Eyl 13, 2017 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.