How to create trend graph from excel data using script in wincc advanced v13

Hello Namdeo123,

to show a graph of a data log in WinCC Advanced runtime you need to replace and access a pre-configured data log:

• Create a .csv file that has the same structure as a data logging .csv file.
  You can do this by creating a data log in WinCC Advanced. Now start the runtime and log some dummy tag. Analyse ths structure. You can re-create it with VBA in an Excel macro.
  I don't have an example project, sorry, but you can find infos via Google.
  Examples: http://analystcave.com/vba-write-file-vba/, http://www.homeandlearn.org/write_to_a_text_file.html and many more).
  Instead of the .csv Format you can use .txt, too.
  You will need some kind of loop through your values in the Excel file.
• Copy your "own" logfile to the position of the old one and replace the old one. Make sure the Archive Name and the names of the logged tags are the same.
  Alternatively, look here:
  • "Long-Term Data Archiving with WinCC Runtime PC and SIMATIC HMI Operator Panels with WinCC (TIA Portal"
    https://support.industry.siemens.com/cs/ww/en/view/109477071

You can look at a graph of your logging file outside the runtime in Excel, too:

• "How can you graphically display the contents of the tag archive of a Comfort Panel or the WinCC Runtime Advanced on the PC without WinCC (TIA Portal)?"
  https://support.industry.siemens.com/cs/ww/en/view/60520367

Might also be interesting:

• "How do you read out or write tag values with an Excel application?"
  https://support.industry.siemens.com/cs/ww/en/view/69846238