Welcome to the quick start guide for the 5dchart Add-In for Microsoft Office Excel.

Select four continuous rows of data and press “Create data sheet”.

qsg1

The data sheet is created automatically and contains all the settings for customizing the appearance of the chart. Please note that data on the datasheet is linked to the initial data, so you don’t need to change it twice. You can have multiple charts and corresponding data sheets for a single portion of the data. See the table below for a description of all the fields in the data sheet.

qsg2

Create a chart by pressing “ReGenerate chart”.

qsg3

You can control view, as follows:
Rotate – hold the right mouse button
Pan – hold Shift + the right mouse button
Change field of view – hold Alt + the right mouse button
Reset camera – press Home key or double click middle mouse button
Set new point of rotation – double-click the right mouse button

Adjust the scale of the bubbles using the S- and S+ buttons.

Copy the chart image to the clipboard by clicking the “Copy to clipboard” button.
Saving the chart image in higher resolutions that are needed for printing is only possible in the purchased version of this add-in. Click “Save image” and choose needed DPI.

You can copy data from the legend and paste it into your presentation or any other document.

The camera position and small chart thumbnail are saved to the data sheet automatically.

Description of the data sheet fields

General

Show legend Enable/disable legend display
Legend numbers Show bubble numbers in the legend
Legend color Show colour indicator for bubbles in the legend
XY pane visible
XZ pane visible
YZ pane visible
Enable/disable axis panes visibility.
0 – disable axis pane
1 – show axis pane with border
2 – show axis pane with border and cross lines
3 – show axis pane with a grid
Background color Define the background colour of the resulting chart.
The evaluation copy will have additional evaluation watermarks
Text color Text colour of chart legend
Text size The text size for the legend text. Default – 100%

Camera

X, Y, Z
Look at X, Look at Y, Look at Z
These cells store data on the last camera position.
Clear all the values to reset to the default position
FOV Field of view

Axes X,Y,Z

Name Name of the axis
Length factor Length factor of the axis.
By adjusting this parameter you can make the axis longer or shorter
Min Minimum value
Crosspoint Point of crossing with other axis
Max Maximum value
Unit Step of the axis
Axis color Colour of the axis line
Show axis name Enable/disable axis name caption
Show unit marks Enable/disable unit marks on the axis
Show unit labels Enable/disable unit labels for one axis
Show min Enable/disable visibility of the min value mark
Show crosspoint Enable/disable visibility of the crosspoint
Show max Enable/disable visibility of the max value mark
Text color Defines the colour of all the captions for the axis
Text size Size coefficient for the axis text captions

Axis S

Name Name of the size axis
Scale Scale factor
Type 1 – scaling as bubble radius (for cube – 1/2 length of side)
2 – scaling as bubble volume

Regression plane

Show plane Enable/disable regression plane display
Color Colour of the regression plane
Width Width coefficient
Length Length coefficient
Cell size The size of a cell
Minor/Major cells Minor/Major grid line intervals
Resulting equation A placeholder for the resulting equation

Bubbles

Name Bubble name
X, Y, Z Bubble position
S Bubble size (Radius or Volume, see Axis S type)
Color, opacity Background – bubble colour, value – opacity. Default – 100%
Type 0 – hidden from chart
1 – sphere
2 – cube
Show label 0 – no label
1 – bubble name
2 – bubble number
3 – bubble size
Label color Bubble label colour
Label text size Bubble label text size factor
XY XZ YZ projection Coefficient for enable/disable Projection of the bubble to the axis panes
XY XZ YZ line Draw line from the bubble to the corresponding axis panes
XY XZ YZ line projection Draw line projections of the axis panes (only if the XY XZ YZ lines are enabled)
Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedIn