How can I export data from Fortran to Excel to plot/ display such as tables or temperature distributions similar to Matlab or how can I plot fortran data?
There is a worked example of exporting to Excel provided in the COM samples called AutoDice. You can now get the samples from https://software.intel.com/en-us/product-code-samples - scroll down to "Intel® Parallel Studio XE for Windows* - Sample Bundle"
You might also look at PGPLOT.
The way I often do this is to write some data tables from Fortran into Excel and then make my charts in Excel. I then save the excel file which is later used as a template i.e. my Fortran programs copies the excel template to a unique name, writes to the exel to re-populate the data tables and then launches the new workboot in excel.
I find this much easier than trying to format and create everything for the excel from the Fortran side.