Excel chart creation 2

Closed

Description

This is an updated re-post of my original project entitled Excel Chart Creation.

I need to create a chart in Excel 2013 that looks like the attached file which was created via a manual "cut and paste" procedure. The challenge is that the chart needs to be both an area, xy, and stacked column format.

There is no specific relationship between the three xy lines except they will always use the same scale. In fact, all three chart formats (xy, area, and stacked column) will use the same scale.

The light blue area chart will always partially overlay the dark blue area chart.

The two stacked columns as shown will always total the same. Additionally, I would like to add 4 more stacked columns. 2 would be associated with the first one shown with the same segmented colors. 2 more would be associated with the second one that is currently shown and will have the same segmented colors as the second currently does. These new columns would not total the same as the existing ones but would use the same scale.

Please advise if you have any questions.

Thanks - Tim

Skills: Excel

See more: relationship challenge, light challenge, formats in excel, excel challenge, create a chart, excel project 2/2, excel 2013, excelchart, excel stacked, stacked area, excel stacked chart, stacked column colors, chart project excel, excel overlay, excel column column, create manual excel, creation paste, create chart, excel chart add, chart creation excel, manual cut paste, create procedure manual, stacked chart, chart excel, create excel file via

Project ID: #5889458

Awarded to:

d2imatrix

Hi Tim, We can do this..I had a look at the data. To create the chart which you are looking for, would require to arrange the data in a little different way. If you want I can start working a little more on this and More

$155 USD in 2 days
(3 Reviews)
3.5
Davidxl

Hello sir, I have the chart made and ready, with colors adjusted to closely match your attached example. I made it in Excel 2007, but the file and chart should be perfectly compatible with Excel 2013. Please award m More

$45 USD in 1 day
(1 Review)
0.9

31 freelancers are bidding on average $109 for this job

maverick44000

Hi Tim. I have looked at the data and the required chart. I can have all the 3 charts created in Excel using VBA macros. Kindly discuss so we may proceed. Regards. Usman.

$200 USD in 2 days
(39 Reviews)
6.0
pkcyber

see my application i have already developed for one of my client. i can develop that for you. where u can simply select data file (excel) and on clicking of a button it will generate the chart as u specified.

$100 USD in 3 days
(29 Reviews)
5.5
srinichal

I am willing to discuss further about the project specifications and deliver the same to your needs .

$252 USD in 5 days
(10 Reviews)
5.1
SoftwareEng8876

Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with me.We can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..

$157 USD in 0 days
(24 Reviews)
4.7
finecodervw

please let me know if it is ok to use Excel 2007 or Excel 2010 for this as these are the versions I have. ============ please share if you have some existing data for the chart. Hi Tim, If you are online, c More

$100 USD in 5 days
(23 Reviews)
4.7
chriskerpini

Hello, There is no way to create one chart like that, it is possible however to have more than one charts with the same scale and vertical axis placed the one near the other, getting the same final result. Why it is More

$110 USD in 2 days
(19 Reviews)
4.7
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More

$147 USD in 1 day
(23 Reviews)
4.6
abdellatif81

Hello TPasbrig, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft More

$105 USD in 2 days
(3 Reviews)
4.4
tomislav1975

Excel VBA expert here. I can do this but with VBA. Graphs are my speciality (see portfolio and reviews).I will do no samples before you hire me and make milestone deposit. Please check my profile and award me now. Cont More

$101 USD in 4 days
(6 Reviews)
3.8
aarifakhtar

Hi: Thanx for providing your requirements in details. Please check my project reviews, (100% completion rate with 5-star rating in all projects). Please connect with me to discuss more.

$88 USD in 3 days
(8 Reviews)
3.6
AndroidAll

Dear sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. If you want, I can develop a demo within a short time. Regards. PS. In order to show my ability, I c More

$150 USD in 3 days
(5 Reviews)
3.4
MasterExcel

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high More

$30 USD in 3 days
(10 Reviews)
3.2
ABHAYS1983

Hi, I am an VBA expert and I believe I can get chart created. Can you please share the original source data which you used to plot the graph. I will make an attempt for plotting before I Bid. If I am successful More

$88 USD in 3 days
(3 Reviews)
1.0
patpogz21

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
seemabangera

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
jovanamalenic

A proposal has not yet been provided

$55 USD in 2 days
(0 Reviews)
0.0
JohnPlant

Interesting. I don't recall trying to anything quite like this before. I am enjoying working on this. I have managed to get the data all in chart to look very similar to your picture. I would like to work with you t More

$40 USD in 3 days
(0 Reviews)
0.0
herryronald

I am a test engineer that develops programs with 8yrs experience - excel has been my constant companion in the development as well as data analysis (in the production area). I would like to help on you this one, and More

$122 USD in 3 days
(0 Reviews)
0.0
rkhyd

The chart can be prepared in excel 2013. The first two data should be assigned to one axis and the third one to second y-axis. A combo chart needs to be selected for this purpose, which is available only in excel 2013. More

$50 USD in 1 day
(0 Reviews)
0.0
nuhin74

AS PER YOUR REQUIREMENT LIKE This is an updated re-post of my original project entitled Excel Chart Creation. WOULD BE A IDLE PROJECT FOR ME AS I,V DONE THIS SORT OF PROJECT BEFORE ON FREELANCER, SO HOPE TO DELIVER WI More

$35 USD in 3 days
(0 Reviews)
0.0