Create a Scatter with Straight Lines chart based on the range E4:G14 in the data table titled GymWear - Break-Even Analysis. Resize and move the chart so that it covers the range
I want urs help to
Create a Scatter with Straight Lines chart based on the range E4:G14 in the data table titled GymWear - Break-Even Analysis.
Remove the chart title.
Add Sales and Expenses as the vertical axis title and Attendees as the horizontal axis title.
Select the range E4:G14. Go to the insert tab. Under charts section, select 'Insert Scatter or Bubble Chart' icon (last option) and then select Straignt Lines chart.
Adding chart automatically adds the title. Just select the title (try to double click if it didn't select in single click) and then hit delete key from keyboard or right click and choose delete option.
To add the text in vertical and horizontal axes, click on the chart. You can see the plus '+' sign at the top-right side of the chart. Click on the '+' sign and mark the 'Axis Titles' as checked. After that, the titles will show up. Double click on the titles and edit the text.
Select the range E4:G14. Go to the insert tab. Under charts section, select 'Insert Scatter or Bubble Chart' icon (last option) and then select Straignt Lines chart.
Adding chart automatically adds the title. Just select the title (try to double click if it didn't select in single click) and then hit delete key from keyboard or right click and choose delete option.
To add the text in vertical and horizontal axes, click on the chart. You can see the plus '+' sign at the top-right side of the chart. Click on the '+' sign and mark the 'Axis Titles' as checked. After that, the titles will show up. Double click on the titles and edit the text.