Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS