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
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
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
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…
Marketing
ISBN:
9781285193946
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
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…
Marketing
ISBN:
9781285193946
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing