ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to create a graph after loading CSV file (https://www.excelbanter.com/charts-charting-excel/163764-how-create-graph-after-loading-csv-file.html)

Leeky

How to create a graph after loading CSV file
 
I would like to automatically create a graph of some data after loading a CSV
file. Perhaps by writing a function in the text of a cell? Or perhaps by
including some VB script?
Is this at all possible? Is there another file format that could be used?

Jon Peltier

How to create a graph after loading CSV file
 
You could record a macro while you create a chart from some imported data,
then rerun the macro after importing each file.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Leeky" wrote in message
...
I would like to automatically create a graph of some data after loading a
CSV
file. Perhaps by writing a function in the text of a cell? Or perhaps by
including some VB script?
Is this at all possible? Is there another file format that could be used?





All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com