Displaying Data in Charts
Displaying Data in Charts
Make your data more comprehensible by displaying the information in a chart. Use bars, lines, bubbles, points, pie charts and more to represent your data and communicate visually with color.
Create Charts
Charts are visually appealing and make it easy for us to see patterns, comparisons, and trends in data. For instance, rather than having to analyze a long list of worksheet numbers, you can see at a glance what categories are producing the biggest impact, or how a variety of elements compare.
To Create a Chart:
- Choose Object | Create Chart... The Chart Options dialog box opens displaying sample data.
- In the Data tab, press Ctrl + A and then click the clear selection button to delete all of the sample data.
- Do one of the following:
- Enter data into the data cells. The first row and column default to chart labels.
- Import data by clicking the File Open icon. Browse to and select your data set (CSV or TXT format).
- Copy data from a spreadsheet and paste into data cells.
- Click the Format Cells button to set number display preferences.
- Click the General, Text, and Series tabs to fine-tune the appearance of your chart.
- Click OK once you have finished editing your chart. Double-click your chart at anytime to display the Chart Options dialog box.
The Chart Options dialog box can also be opened by clicking the Chart icon 
found in the toolbar.
Notes on Importing CSV (Comma Separated Values File) and TXT File Formats
- Every row (with the exception of the last) should end in a carriage Return.
- With the exception of labels, numerical values of thousands should not contain commas (,).
- With the exception of labels, characters are imported as follows:
Character | Example (in CSV or TXT file) | Result (in Chart) | |
- | -1.00 | -1.00 | |
() | (1.00) | -1.00 | |
% | 1.00 % | 0.01 (1 divided by 100) | |
$ | $1.00 | 0 | |
$() | $(1.00) | 0 (any string is imported as zero) | |
or | 1.00 or 2.00 | 1.00 2.00 |
Pie charts are generated counter-clockwise from the 1st data cell. To reverse the order, sort your data using a spreadsheet program and copy and paste the data back into the Chart Options dialog box.
You can save your settings as a preset by clicking the Set as Preset button.
Recent Articles
Quick Reference Guide for canvasxdraw 26 for Windows
Click to view and download the Quick Reference Guide for canvasxdraw version 26. Other related links: Getting Started Guide: https://help.vectorgfx.net/en/canvas_x_draw/getting_started/canvas_x_draw_getting_started.pdf User Guide: ...Quick Reference Guide for canvasxdraw 26 for macOS
Click to view and download the Quick Reference Guide for canvasxdraw version 26. Other related links: Getting Started Guide: https://help.vectorgfx.net/en/canvas_x_draw/getting_started/canvas_x_draw_getting_started.pdf User Guide: ...User Guide for canvasxdraw 26 for macOS
Click to view and download the User Guide for canvasxdraw version 26. Other related links: Getting Started Guide: https://help.vectorgfx.net/en/canvas_x_draw/getting_started/canvas_x_draw_getting_started.pdf Quick Reference Guide: ...User Manual for canvasxdraw 26 for Windows
Click to view and download the User Guide for canvasxdraw version 26. Other related links: Getting Started Guide: https://help.vectorgfx.net/en/canvas_x_draw/getting_started/canvas_x_draw_getting_started.pdf Quick Reference Guide: ...Getting Started Guide for canvasxdraw 26 for Windows
Click to view and download the Getting Started Guide for canvasxdraw version 26. Other related links: Quick Reference Guide: https://help.vectorgfx.net/en/canvas_x_draw/quick_reference/canvas_x_draw_quick_reference.pdf User Guide: ...
Related Articles
Displaying Data in Charts
Displaying Data in Charts Make your data more comprehensible by displaying the information in a chart. Use bars, lines, bubbles, points, pie charts and more to represent your data and communicate visually with color. Create Charts Charts are visually ...Seismic Data
Seismic Data The global energy marketplace is a continually transforming one where sometimes change is the only thing that remains constant. In order to stay at the forefront, companies have to keep up with the latest technologies and develop the ...Accessing Image Data
Accessing Image Data Canvas X Draw contains important features that allow you to analyze an image’s pixel values and measure various image properties: Image Data Viewer tool, View Data command, and Image Measurement command. Image Data Viewer Tool ...Exporting and Importing Geometric Data
Exporting and Importing Geometric Data Canvas X Draw lets you export numerical data about a geometric object to a text file. You can also import geometric data from a text file or from a .CSV file. Exporting Geometric Data To Export Geometric Data: ...Data Acquisition, Visualization and Analysis
Data Acquisition, Visualization and Analysis Canvas X Draw has the ability to accurately measure, analyze, and export digital images that may contain up to 32 bits per channel of data. Specialized imaging instrumentation within the medical, ...
Popular Articles
Version 26 released for all products!
New versions have arrived! Version 26 includes the first macOS universal app compatable with all macOS versions and chipsets! Installers, upgrades, and trial links below: Installer: canvasxdraw version 26 for macOS | Perpetual macOS users looking to ...User Guide for canvasxdraw 26 for macOS
Click to view and download the User Guide for canvasxdraw version 26. Other related links: Getting Started Guide: https://help.vectorgfx.net/en/canvas_x_draw/getting_started/canvas_x_draw_getting_started.pdf Quick Reference Guide: ...Welcome to Vector GFX!
Please bear with us as we are busy updating all of our help content. If you need immeadiate assistance submit a ticket at https://vgfxsupport.zohodesk.com/portal/en/newticket or e-mail info@vectorgfx.net. Other important links: * New: Website: ...Vector GFX: Quality Assurance Program Overview
Vector GFX: Quality Assurance Program Overview At Vector GFX, we are committed to delivering high-performance, stable desktop solutions. Because our software resides directly on our customers' local environments, our Quality Assurance (QA) program ...How many computers can I put a license on?
Overview: Each license can only be used to register the program on two computers. If you are looking to get more than one license, we can offer a discount for multiple licenses. Please contact our sales department at sales@vectorgfx.net. Applies To: ...