Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
CSV Data
Although your model contains a great deal of information on both project design and project management, you might want to check or present the status of some external spreadsheet data for comparison or for review before importing it into your model. A major benefit of the Chart feature is providing the facility to quickly paste in and display, in the appropriate Chart format, the contents of an external CSV file.
Before you start, copy the content of the CSV file to the clipboard.
Access Double-click on Chart element | Chart Details | Source > CSV
Review External CSV Data
Field/Button |
Action |
See also |
---|---|---|
panel |
Right click on the panel and select the 'Paste' option to paste the contents of the CSV file. If necessary, edit the data so that the first row defines the series name, in the format: Series,Name1,Name2,Name3... Edit the first column to represent the series object (the objects listed along the x-axis of the Chart). You need perform only very basic editing on the text. |
|
OK |
Click on this button to process the data, close the dialog and generate the Chart. |
|
Cancel |
Click on this button to abort the changes and close the dialog. |
Output
Using simple CSV input such as this, for two chart elements Fruit Sales (tonnes) and Fruit Sales (No Series), two bar charts were created.
Series,Jan,Feb,March,April,May
Apples,15,20,45,50,57
Oranges,25,45,50,55,60
The CSV data for Fruit Sales (tonnes) provides a label for the series, essentially the aspect being compared (the sales for each month). The data for Fruit Sales (No series) omitted the first line of information, so the chart defaults to an unnamed series set.
Learn more