ENTERING NEGATIVE VALUES

<< Click to Display Table of Contents >>

Navigation:  Chart Creation >

ENTERING NEGATIVE VALUES

Previous pageReturn to chapter overviewNext page

Certain charts, by their nature, will not accept negative numbers.

 

NEGATIVE NUMBER RESTRICTIONS

Negative Values are permitted for the following charts:

Marimekko, Bar-Mekko, Stacked Bar, Cluster Bar, 100% Stacked Bar, Waterfall, Line, and Pie chart,  (a Pie chart interprets a negative value as a positive value).

THE FOLLOWING RESTRICTIONS APPLY TO THE BUBBLE AND SCATTER CHARTS.

XY Linear Bubble - both X and Y values may be negative, but bubble size must be a positive number.

X Log Bubble- X Log value must be greater than zero, and bubble size must be positive number.

Y Log Bubble - Y Log value must be greater than zero, and bubble size must be a positive number.

XY Log Bubble - Both X and Y log values must be greater than zero and bubble size must be a positive number.

Growth-Growth - both X and Y values may be negative, but bubble size must be a positive number.

Growth-Share - X values must be greater than zero, and bubble size must be a positive number.

ROS ROA vs RMS - X values cannot be greater than zero, and bubble size must be a positive number.

XY Linear Scatter - both X and Y values may be negative

X Log Scatter - X Log value must be greater than zero

Y Log Scatter - Y Log value must be greater than zero

XY Log Scatter - Both X and Y log values must be greater than zero

 

SHOWING NET VALUES OF BARS

When a bar has both positive and negative segments, you can choose to only display net effect of positive and negative bars.  Go to the Format Chart Task Pane, General tab, and check the Show Net Bar Total checkbox.

 

REVERSE ORDER FOR NEGATIVE SEGMENTS

One of your sorting options is the option to reverse the display order for negative segments in your chart. If you choose to reverse your display of negative segments in your chart, your chart will display the spreadsheet sort order you have selected, but will reverse the spreadsheet order for all the negative segments in the bar.