Displaying Data in Charts

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:

  1. Choose Object | Create Chart... The Chart Options dialog box opens displaying sample data.
  2. In the Data tab, press Ctrl + A and then click the clear selection button to delete all of the sample data.
  3. 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.

  4. Click the Format Cells button to set number display preferences.
  5. Click the General, Text, and Series tabs to fine-tune the appearance of your chart.
  6. 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.001.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.

    • 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, ...