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
I'm attaching the data that can be used to either demo or create the final chart. Of course the data will change so the chart needs to update itself accordingly. Thanks.
31 freelancers are bidding on average $109 for this job
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.
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.
Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [url removed, login to view] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..
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.