Home
Using HCL Connections Docs 2.0 CR3
Welcome to the HCL Connections Docs 2.0 CR3 documentation, where you can find information about HCL Docs 2.0 CR3. HCL Docs is a collaborative productivity suite that enables you to work on documents, spreadsheets and presentations together in the cloud.
Using HCL Docs
HCL Connections™ Docs is a new office productivity suite for working on documents, spreadsheets and presentations together. It provides real-time co-editing, allowing users to work on documents individually or collaboratively. Comment on a document, or even participate in a discussion. All this without the need of desktop software.
Working with spreadsheets
Calculate, analyze, and manage your data. Several categories of functions are available to create formulas to perform complex calculations on your data.
Working with charts in spreadsheets
You can insert a chart into a spreadsheet, and then resize, move, and delete the chart.
Chart types in spreadsheets
When you want to show comparisons and trends in a series of data, you can create charts in spreadsheets.
Scatter charts
You can use scatter charts to show the relationships among the numeric values in several data series, or display two groups of numbers as one series of xy coordinates. Data in columns or rows on a sheet can be transformed into a scatter chart.

Using HCL Connections Docs 2.0 CR3
Welcome to the HCL Connections Docs 2.0 CR3 documentation, where you can find information about HCL Docs 2.0 CR3. HCL Docs is a collaborative productivity suite that enables you to work on documents, spreadsheets and presentations together in the cloud.
- Using HCL Docs
  HCL Connections™ Docs is a new office productivity suite for working on documents, spreadsheets and presentations together. It provides real-time co-editing, allowing users to work on documents individually or collaboratively. Comment on a document, or even participate in a discussion. All this without the need of desktop software.
  - Accessibility features for HCL Docs
    Accessibility features assist users who have a disability, such as restricted mobility or limited vision, to use information technology content successfully.
  - Supported browsers
    See what Web browsers are supported by HCL Connections™ Docs.
  - What's new in HCL Docs 2.0
    Learn about new features and functions in HCL Docs 2.0.
  - Publishing a version of a file
    In order for readers to see a draft created in HCL Connections Docs, or edits made in Docs, a new version of the file must be published. As of August 2015, if a file is being created or edited in Docs for the first time, publishing is set to occur automatically. If a file was previously created or edited in Docs, you must either enable the Publish Automatically command in that file, or publish each new version manually.
  - What if I have a file conflict?
    A person can decide to upload a new version of a file while another person is editing the file online or has saved an online file that is not yet published. The new uploaded version is stored in Files as its own version number, and you are warned of the conflict the next time you try to edit the file from the Files list.
  - Reverting to last version
    When you are editing in HCL Connections™ Docs, if you are not satisfied with the current version of your document, you can revert to the last version that was published. You can choose to save or discard your current edits before you revert to the last version of a document.
  - Viewing a file by using the viewer
    You can view an uploaded document, spreadsheet, presentation, or PDF file while you are working in Files.
  - Accessibility features for HCL Docs
    Accessibility features assist users who have a disability, such as restricted mobility or limited vision, to use information technology content successfully.
  - Working with documents
    Work on a document by yourself or collaborate on files with your colleagues. You can comment on a document, or even participate in a discussion. All this in real-time. Upload an existing Open Document Format or Microsoft™ Word file or create a document to begin.
  - Working with spreadsheets
    Calculate, analyze, and manage your data. Several categories of functions are available to create formulas to perform complex calculations on your data.
    - Creating and importing spreadsheets
      Learn how to create spreadsheets and work with existing spreadsheets in your web browser.
    - File compatibility and exporting spreadsheets
      Find out which file types you can use with HCL Connections™ Docs spreadsheets.
    - Working with spreadsheets in Content Navigator
      If your organization uses IBM Content Navigator as its file repository, see the following topics to learn how to create, import, check in, and save spreadsheet files in the repository.
    - Sharing spreadsheets
      You can make a spreadsheet public for anyone to read, or share it with specific people and communities. You can allow people to edit a spreadsheet and even share it with others. You can also change or delete access levels after you share a spreadsheet.
    - Collaborating on spreadsheets in real time
      You can collaborate on a spreadsheet in real time with others as a team. You can co-edit with other editors in real time, and create comments and discussions.
    - Changing the look of your spreadsheets
      Simple enhancements to the way your spreadsheets look can improve their effectiveness.
    - Managing sheets in spreadsheets
      You can insert a sheet into a spreadsheet, and then move, rename, hide and show the sheet. For an overview of the basics and for tasks that you might need help with, see the following topics.
    - Formatting numbers
      A number can look different from the actual value entered in a cell, depending on the number format. Number formats differentiate one kind of data from another; for example, currency from percentages. Number formats affect only how HCL Connections™ Docs displays numbers, not how it stores or calculates numbers.
    - Entering and editing data
      Most editing tasks in HCL Connections™ Docs are easy to do on your own. For an overview of the basics and for tasks that you might need help with, see the following topics.
    - Working with images in spreadsheets
      You can insert an image into a spreadsheet, and then resize and move the image.
    - Working with charts in spreadsheets
      You can insert a chart into a spreadsheet, and then resize, move, and delete the chart.
      - Chart types in spreadsheets
        When you want to show comparisons and trends in a series of data, you can create charts in spreadsheets.
        Column charts
        You can use column charts to show data comparisons among items or data changes over a period of time. Data in columns or rows on a sheet can be transformed into a column chart.
        Bar charts
        You can use bar charts to illustrate comparisons among individual items. Data in columns or rows on a sheet can be transformed into a bar chart.
        Pie charts
        You can use a pie chart to show the relationship of parts to the whole. Data in columns or rows on a sheet can be transformed into a pie chart.
        Area charts
        You can use area charts to emphasize the magnitude of change over time and the total value across a trend. You can also use area charts to show the relationship of parts to a whole. Data in columns or rows on a sheet can be transformed into an area chart.
        Line charts
        You can use line charts to display continuous data over a period of time at a common scale. Therefore, line charts are ideal for showing data trends at equal intervals. Data in columns or rows on a sheet can be transformed into a line chart.
        Scatter charts
        You can use scatter charts to show the relationships among the numeric values in several data series, or display two groups of numbers as one series of xy coordinates. Data in columns or rows on a sheet can be transformed into a scatter chart.
      - Inserting charts in spreadsheets
        You can insert a chart into a spreadsheet.
      - Moving and resizing charts in spreadsheets
        Move and resize charts in spreadsheets by dragging.
      - Copying charts in spreadsheets
        You can use keyboard shortcut keys to cut, copy, and paste charts within and between spreadsheets.
      - Changing data source ranges
        Use the Chart Settings window to change a chart's data source ranges without having to redo the chart in the sheet.
      - Setting chart properties in spreadsheets
        You can customize a chart's font, title, legend, background, border, and style of chart type.
    - Managing data ranges
      Learn how to sort data in a sheet or range and reference data that is on a different sheet.
    - Using formulas in calculations
      This section provides background information on formulas and functions, and organizes the functions in alphabetical order or by category to make it easy to find related functions.
    - Spreadsheets quick reference
      This topic helps you discover or remember how to do certain spreadsheet tasks.
    - Spreadsheets keyboard shortcuts
      You can use shortcut keys to perform tasks in spreadsheets. All shortcuts are valid on Windows™ operating systems. On Mac OS, press Command instead of Ctrl.
  - Working with presentations
    Create high impact, professional presentations. Or, you can upload existing presentations from your computer to HCL Docs Cloud for online editing. You can edit presentations with your colleagues in real-time and collaborate with others through comments and discussions.
  - Glossary
  - Notices

Scatter charts

You can use scatter charts to show the relationships among the numeric values in several data series, or display two groups of numbers as one series of xy coordinates. Data in columns or rows on a sheet can be transformed into a scatter chart.

Scatter charts are typically used for displaying and comparing numeric values, such as statistical data. A scatter chart has two value axes, showing one set of numeric data along the horizontal axis (x-axis) and another along the vertical axis (y-axis). These values are combined into single data points and displayed at irregular intervals.

You can use a scatter chart in the following cases:

There are many data points on the horizontal axis.
You want to change the scale of the horizontal axis.
The values for the horizontal axis are not evenly spaced.
You want to show similarities between large sets of data instead of differences between data points.
You want to effectively display worksheet data that includes pairs or grouped sets of values and adjust the independent scales of a scatter chart to reveal more information about the grouped values.
You want to compare many data points without regard to time - the more data that you include in a scatter chart, the better the comparisons that you can make.

Scatter charts have the following chart subtypes:

Scatter with only markers
If you have many data points and do not have to show the connectivity of data points, use a scatter chart with only markers. Connecting lines would make the data more difficult to read.
Scatter with smooth lines and scatter with smooth lines and markers
These types of charts display smooth curves which connect the data points. If there are many data points, use a smooth line without markers.
Scatter with straight lines and scatter with straight lines and markers
These types of charts display straight connecting lines between data points.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box. Note: To report a problem or question about the product software, do not use this form. Instead, go to the HCL Software Support site.