In Progress

Expert in Excel Needed to Create Advanced graphs

Guidelines for Excel project:

I would like several double y-axis charts that can be created by selecting inputs from a series of drop down menus, the data for the dropdown menus will be refreshed on a weekly basis and will the charts need to be flexible enough to allow for new data measures to be added periodically.

The purpose of the graphs is to report sales measures for a branded drink manufacturer.

The best way to demonstrate what I require is by looking through the attached spreadsheet.

I would like to produce graphs like the one on the 'Juiced graph' and 'Juiced graph 2' tabs by selecting from some or all of the following inputs:

Select customer(s)

Select Manufacturer(s)

Select Brand(s)

Select Size(s)

Select Flavour

Select measure (left hand axis)

Select measure (right hand axis)

On the 'Juiced data selection' tab you'll see the above list in the 'Topline data selection tabs' column, along with a selection of options on 'Data selection tab options' column that a user can choose from taking inputs from 'Juiced data 'and then example columns with the selections that a user would have been required to make to create 'Juiced graph' and 'Juiced graph 2' tabs.

You'll see that 'Juiced graph' uses data from 'Juiced data' and then 'Juiced graph 2' requires the aggregation of data contained in the 'Juiced data' tab.

I would like you to create a graph for each data tab, so 'Juiced data', 'TOF data', 'Plain data, 'Evian data', 'Baodit data' and 'Total data' with each graph being created by the user selecting from the various drop down inputs relating the each 'data' tab. The data is refreshed every week, the number of weeks does not change, i.e. the weeks are taken on a rolling basis, but the data relating to each column may change as new products are introduced to the market. The data labels for the drop down inputs in the top row will not change, the weeks names will change as a new week comes in and the oldest week goes out, but there will always be 52 weeks.

If possible I would also like the selection available from each tab to be limited by the users selection in the prior tab. For example, for 'Juiced data' if the user selects 'Feel Good Drink' as the brand then, they'll be limited to the Sizes available for Feel Good Drinks.

For the graph, I'd like the right hand axis measures to be dotted (as in both Juiced graph examples). When the graph has product level data (e.g. in Juiced Graph), I would like the products measures to be in the same colour but one in a solid line for the left axis and a dotted line for the right axis.

Skills: Excel

See more: what is graphs, what are graphs for, what are graphs, top graph, rolling tab, looking for excel expert, graph top, graph to data, graphs uses, graphs of data, graph graphs, graph data examples, expert with excel, excel 0 to expert, example of graphs, data for graphs, data and graphs, create line graph, create graphs, create graph, create charts and graphs, create a line graph, create a graph, create a double line graph, best graphs for data

About the Employer:
( 95 reviews ) London, United Kingdom

Project ID: #4505266

Awarded to:


I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I have read your requirement and also see your attachment. I am confident to create this dynamic c More

$111 USD in 3 days
(13 Reviews)

14 freelancers are bidding on average $153 for this job


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

$200 USD in 3 days
(52 Reviews)

##### Excel expert here! Please check PM. #####

$183 USD in 3 days
(41 Reviews)

Dear David, I can do it. I'm a programmer for years and very familiar with VBA for excel automation. I can make a user form with predefined combo box for user to set the graph configuration as you need. then click More

$150 USD in 10 days
(20 Reviews)

Excel Expert. Please check PM for details. Thanks.

$222 USD in 3 days
(14 Reviews)

we can be of good help for ur project

$166 USD in 3 days
(15 Reviews)

Simple one for me. Ready to initiate. PMd

$170 USD in 3 days
(4 Reviews)

I am experienced in excel & I am confident about the completion of the work timely. Thanks

$30 USD in 1 day
(2 Reviews)

Respected sir , Warn Greeting to You Sir i have done this type of work before it and i am having 30 to 35 wpm typing speed and i assured you will be happy by seeing my work Skype Id - [url removed, login to view] Hoping More

$155 USD in 3 days
(1 Review)

Hi, I am highly qualified to do this job. Regards

$166 USD in 7 days
(0 Reviews)

I am an expert in Excel and the task is doable.

$155 USD in 3 days
(0 Reviews)

I have the experience to make this project a success for you without all the normal headaches one can experience when outsourcing this type of expertise.

$155 USD in 3 days
(0 Reviews)

need job and need money

$163 USD in 7 days
(0 Reviews)

hi Excel graph expert here. i have done exactly the type of dynamic graphs. Please check PM for my similar previous successful project. PM me ASAP, so we can start working. Thanks & Regards,

$111 USD in 3 days
(0 Reviews)