Excel graph -- Need answer fast. Should be simple.

[Johnny_L.A]

@Saintly_Loser

I think that’s probably a view setting in Excel on your computer, and has nothing to do with the chart. At least that’s how I make my chart look like that. In the View tab, turn off gridlines and headings (probably everything).

I don’t think that’s it. The second chart (number of pilots) seems to have the chart and nothing else on the sheet. The first one, I can get rid of grid lines, but the spreadsheet is still there. (I can click outside of the chart, and a cell is highlighted.)

[Peter_Morris]

@Johnny_L.A

2. What I was getting at was that I want the sheet to look like the other one. That is, no spreadsheet behind the chart. i.e., I just want the chart on the sheet, and nothing else.

Right click the chart

select “location” from the menu

select “as new sheet” option

[Johnny_L.A]

@Peter_Morris

Right click the chart

select “location” from the menu

select “as new sheet” option

Oops. Tried that. It split the chart between two spreadsheets. Deleted it, and now it’s gone. Can’t undo. I’ll have to re-make the chart.

EDIT: Or just close it and opened the saved file…

.

[Johnny_L.A]

OK…
To:
Display the chart in a new chart sheet

Do this:
Select the New sheet option, and then in the New sheet box, type a name for the new chart sheet.

Close enough for government work.

[K364]

When you have a table of data in Excel, always format the heading rows and columns (if you have them) differently than the data itself. That will help Excel when it makes assumptions about how to create charts, how to sort, etc.