Concluído

excel - update line chart based on selections

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.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Matemática, Visual Basic

Veja mais: how to create a dynamic chart with drop-down list, excel chart based on formula, select data to display in an excel chart with option buttons, excel chart with drop down menu, excel chart drop down filter, dynamic chart excel, how to use drop down menus to make interactive charts and dashboards in excel, drop down menus for dynamic dashboards, web based application form design sample template, excel line chart csv, aspnet line chart sample, based slider line chart data provider flex, based slider line chart updates flex, create line chart year monthly sales excel, generate line chart excel linux, excel vba add line chart, expert excel line chart, excel 2010 line chart pivot table, excel line chart csv data, how to auto update a chart after entering new data in excel

Acerca do Empregador:
( 5 comentários ) Pagewood, Australia

ID do Projeto: #18759519

Concedido a:

Capitan0Trueno

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 t Mais

$20 NZD em 0 dias
(36 Comentários)
4.9

13 freelancers estão ofertando em média $21 para esse trabalho

TonmoyRoy111

Hello client I can do this for you. Please contact me. Roy ........................................................

$20 NZD in 0 dias
(311 Comentários)
6.7
asadkhan3533

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 em 1 dia
(119 Comentários)
6.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$20 NZD em 1 dia
(86 Comentários)
5.5
jasalaz100

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 com Mais

$20 NZD in 0 dias
(32 Comentários)
4.9
Ahmed818

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:// Mais

$19 NZD in 0 dias
(40 Comentários)
4.3
SousaTranslation

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 autocomplet Mais

$20 NZD em 1 dia
(14 Comentários)
3.9
jameskaikai

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 in 0 dias
(12 Comentários)
3.6
engcmp

1. 4 Years' experience as full stack developer from freelancer 2.Self-directed and motivated Software Engineer works effectively in dynamic environments. 3. Fluent in a lot of web languages such as php, javascript Mais

$30 NZD em 1 dia
(0 Comentários)
0.0
$14 NZD in 10 dias
(0 Comentários)
0.0
jhenfher

Hi I’m Jenifer Mena, I would like to bid to your project for as low cost for only $23 for 1 day. My current work now is doing payroll and admin staff which allows me to type and do task everyday dealing with number/nam Mais

$23 NZD in 10 dias
(0 Comentários)
0.0
Harmohit

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. Regard Mais

$20 NZD em 1 dia
(1 Comentário)
0.0
vmeono001

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 em 1 dia
(0 Comentários)
0.0