Excel vba, macro function for Excel to turn csv to svg graphs -- 2
$10-30 USD
Teslim sırasında ödenir
Hi, I've got a monthly report we do on our servers for the client.
Currently, we will capture the live feed graphs from the server for the period.
What I hope to achieve is to generate a svg graph for the year and one for each month based on the csv files saved for the year, with macros and functions so that other tables can be automated. This graphs should be placed in a Word form as a report.
You need to deliver your work in an Excel file with the functions included, then to be integrated in the Word report. You may need to explain how to use it too.
If possible, I will give you the server access to access the graphs it generates and the values. But before proposing, please check the attached files and if possible, show the sample outputs from the csv file.
my budget: usd 20
here's example code
Do Until [login to view URL] = True
[login to view URL] "SELECT * FROM m_vals WHERE deviceIndex=" & [login to view URL]("deviceIndex"), cn, , , adCmdText
Do Until [login to view URL] = True
' srchDvcIdx = "=" & [login to view URL]("deviceIndex").Value
' mtchField = [login to view URL]("deviceIndex", [login to view URL](1), 0)
'
' [login to view URL] _
' Field:=mtchField, _
' Criteria1:=srchDvcIdx, _
' Operator:=xlAnd
' Set dvcRange = [login to view URL](CLng([login to view URL]("deviceIndex").Value), LookIn:=xlValues)
' Set cht = [login to view URL]
' [login to view URL] Source:=dvcRange
' [login to view URL] = xlXYScatterLines
[login to view URL]
Loop
[login to view URL]
[login to view URL]
Loop
Proje NO: #24044197
Proje hakkında
Bu iş için 7 freelancer ortalamada $18 teklif veriyor
Hi Mr/Ms, I am absolutely sure that I can do the project very well. I am working as worker and over past 5 years of experience. I have worked on several similar projects and can deliver quality notes to tight deadlines Daha Fazla
hi. I dola pradhan. your project is completed read. i understand your project. I completed in this time.
I am not sure if you have any questions or concerns please visit the lockouts page and the other day and time for you to know if you want to do it for a couple of years sorry want wrong latter
I have seen your project description. After that I am able to understand that I have enough skills to do the project.
I will write and provide many high-quality SEO BLOG, WEB CONTENT or ARTICLE WRITING for any niche, for either your BLOG POST or website with 24hrs delivery and with free revisions if needed!
Hello For svg graph it is difficult to convert in excel but i can use some tricks and tools to do that. Some online tools are there or have yo use java. Need some time to start with. Will attch sampl Relevant Skills Daha Fazla
