<< Click to Display Table of Contents >> ENTERING NEGATIVE VALUES 

Certain charts, by their nature, will not accept negative numbers.
NEGATIVE NUMBER RESTRICTIONS
Negative Values are permitted for the following charts:
Marimekko, BarMekko, 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.
GrowthGrowth  both X and Y values may be negative, but bubble size must be a positive number.
GrowthShare  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.