Format Axis ✓ Axis Options Text Options ✓ Axis Options Bounds Minimum 3500.0 Reset Maximum 7500.0 Reset Units Major 500.0 Auto Minor 100.0 Auto Vertical axis crosses O Automatic Format Axis ✓ Axis Options Text Options Vertical axis crosses O Automatic O Axis valug ○ Maximum axis value Display units None 3500.0 Show display units label on chart Logarithmic scale Base 10 Values in reverse order > Tick Marks How it should look Net Income My chart and how its entered $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 50 -$300,000 3,500 4,000 4,500 5,000 5,500 6,000 6,500 7,000 Hours Contracted 7,500 Format Axis Format Axis ✓ Axis Options Text Options ✓ Axis Options Text Options Number ✓ Axis Options Category Bounds Currency Minimum -100000.0 Reset Decimal places: 0 Maximum 650000.0 Reset Symbol: Units Major 100000.0 Auto Minor 20000.0 Auto Negative numbers: Horizontal axis crosses -$1,234 ○ Automatic O Axis valug $1,234 -100000. ($1,234) $270.00 $280.00 $290.00 $300.00 $310.00

Foundations of Business (MindTap Course List)
6th Edition
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Chapter15: Using Management And Accounting Information
Section15.8B: Financial Ratios
Problem 1CC
icon
Related questions
Question

Hello,

can somone help me with the axis? It is not going crossing at the -100,000.

Change the Bounds Axis Options for the new chart as follows:

Change the Minimum Bounds of the vertical axis to -100,000 and the Maximum Bounds to 650,000.

Set the horizontal axis to cross at the axis value -100,000.

Change the Number format of the vertical axis to Currency with 0 Decimal places and $ as the Symbol.

Change the Minimum Bounds of the horizontal axis to 3,500 and the Maximum Bounds to 7,500.

I have attached what I have entered, how my chart looks and how the chart is expected to look.

 

 

Format Axis
✓ Axis Options
Text Options
✓ Axis Options
Bounds
Minimum
3500.0
Reset
Maximum
7500.0
Reset
Units
Major
500.0
Auto
Minor
100.0
Auto
Vertical axis crosses
O Automatic
Format Axis
✓ Axis Options Text Options
Vertical axis crosses
O Automatic
O Axis valug
○ Maximum axis value
Display units
None
3500.0
Show display units label on chart
Logarithmic scale Base 10
Values in reverse order
> Tick Marks
How it should look
Transcribed Image Text:Format Axis ✓ Axis Options Text Options ✓ Axis Options Bounds Minimum 3500.0 Reset Maximum 7500.0 Reset Units Major 500.0 Auto Minor 100.0 Auto Vertical axis crosses O Automatic Format Axis ✓ Axis Options Text Options Vertical axis crosses O Automatic O Axis valug ○ Maximum axis value Display units None 3500.0 Show display units label on chart Logarithmic scale Base 10 Values in reverse order > Tick Marks How it should look
Net Income
My chart and how its entered
$600,000
$500,000
$400,000
$300,000
$200,000
$100,000
50
-$300,000
3,500
4,000
4,500
5,000 5,500 6,000 6,500 7,000
Hours Contracted
7,500
Format Axis
Format Axis
✓ Axis Options
Text Options
✓ Axis Options
Text Options
Number
✓ Axis Options
Category
Bounds
Currency
Minimum
-100000.0
Reset
Decimal places: 0
Maximum
650000.0
Reset
Symbol:
Units
Major
100000.0
Auto
Minor
20000.0
Auto
Negative numbers:
Horizontal axis crosses
-$1,234
○ Automatic
O Axis valug
$1,234
-100000.
($1,234)
$270.00
$280.00
$290.00
$300.00
$310.00
Transcribed Image Text:Net Income My chart and how its entered $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 50 -$300,000 3,500 4,000 4,500 5,000 5,500 6,000 6,500 7,000 Hours Contracted 7,500 Format Axis Format Axis ✓ Axis Options Text Options ✓ Axis Options Text Options Number ✓ Axis Options Category Bounds Currency Minimum -100000.0 Reset Decimal places: 0 Maximum 650000.0 Reset Symbol: Units Major 100000.0 Auto Minor 20000.0 Auto Negative numbers: Horizontal axis crosses -$1,234 ○ Automatic O Axis valug $1,234 -100000. ($1,234) $270.00 $280.00 $290.00 $300.00 $310.00
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Foundations of Business (MindTap Course List)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Foundations of Business - Standalone book (MindTa…
Foundations of Business - Standalone book (MindTa…
Marketing
ISBN:
9781285193946
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing