is there anyone out there who can help me with the macro.. It gives the fault 1004 with I try to run it.. :/ I did everything like in the video on the site.
Please ASAP need this.
Excel MACRO
Re: Excel MACRO
Some non English versions of Excel do not understand the Comma part of the Comma Separated Values (CSV) file.
If this is the case you will find when opening a CSV file that all the values will show in the first column.
To fix it, you will need to click "Text to columns" in the "Data" tab. Then select "Delimited" and "Comma".
You can now run the Macro.
However, I would strongly advise you to just use the online charts! The Excel macro is really only for people who want to write their own custom code to parse the values. Excel is not very good at rendering graphs with lots of data in.
If this is the case you will find when opening a CSV file that all the values will show in the first column.
To fix it, you will need to click "Text to columns" in the "Data" tab. Then select "Delimited" and "Comma".
You can now run the Macro.
However, I would strongly advise you to just use the online charts! The Excel macro is really only for people who want to write their own custom code to parse the values. Excel is not very good at rendering graphs with lots of data in.