Cannot Delete Unwanted X Axis Cell

Thanks, yes, the far left column was correctly selected, somehow CU got included. So is the only other alternative (other than finding another data table and copying it's correct x values labels, which I did in the case above) to delete the whole chart and start over?

Because even when I do create a new chart, (to plot another data table), I am having difficulty getting Numbers to plot what is represented in the table (in a new sheet called v13 that is a duplicate of the old v12 sheet imaged above) because the chart curve in v13 faces the wrong way.

The lines of the Delta chart were facing the correct way: (v12)

In v13 I altered the order of values for the x axis (in the light blue column G) so they now ascend in value from the bottom (asset price 167) of the table with the top having the highest value (447). My v12 sheet asset price X values, had originally had the smallest values at the top of the column descending to the largest value at the bottom. 

In v13 I decided to copy the labels but no amount of rearranging the cell references in sheet v13 in the category labels, eg by dragging references from the top of the column G to the bottom, stopped the sigmoid Delta curve -- that should have the lowest values on its bottom left and be sloping up to the right with the highest values -- being back to front? I then realised the v13 labels will always reference v12…

I created a new chart in v13 and selected my first column of Delta values (blue dot) in col i. but despite moving x values that have defaulted to the far left column over to col G, by simply dragging from the left column to column G (asset prices) the chart curve still keeps facing the wrong way, (an incorrect backward S) even if I drag references from the top of the column to the bottom and vice versa, one buy one same problem with the chart slope direction... and this despite the chart having x values on the bottom far left (asset price 167 / Delta 0.0017) going to 447 and Delta = 1.0000 on the far right?

I'm not sure why a new chart with every single x axis value dragged from left to the col G position (unlike in ths image of another attempt at t new chart) is still "back to front."

Also how do you stop Numbers selecting the far left column when you plot your first Y axis Delta value with a blue dot selection?

Cheers!

Re: My response below about editing category labels and wrong facing chart curves... I can only assume the direction in which you select the vertical columns (Delta's) will determine how Numbers plots the data.

Deleting my "Blue Dot" Selection and individually selecting values, cell by cell, going up the column from the bottom to the top row "solved" the chart curve direction (it's now right facing). I find it strange that you can't select the column from the top and it respects the values in the x axis and why the selected column's blue dot appears where it does at the bottom of the column obscuring data?

I don't know why reversing the x axis data would delete all my chart data leaving them blank and back to "factory settings" with an "add chart data" needed to redraw all the charts? 😅 Surely reversing x axis data shouldn't be this complicated?

Yet selecting another columns form the bottom up and the green dot is okay and appears above the selection for this newly added column?

I understand it's hard to figure without seeing everything selected and appreciate your responses here. Thanks for the x axis re-selection advice.

I am pretty certain when I started making charts that didn't use rows of days, 90,89,88 etc as the x axis i manually selected those far left header column "implied volatility etc" selections and dragged them over to the light blue asset price columns in col G. That worked. Sheet v12 charts on the whole all looked fine (aside from the odd random cell that got inadvertently selected within a charts data and as you noted can't be removed from the category label).

Sheet v12 (yesterdays version with descending x axis asset prices) was fine:

Sorry it's so small, this is its source to the left of the chart.

The v13 sheet as you know now has the col G asset prices reversed and now ascending. What I am struggling with is how to select those vertical columns like above because I am still getting wrong facing chart lines that don't respect the data in the table, albeit with it's new direction for the x axis data (I saw all the gamma values update and they are correct in the tables).

I selected the blue column which is pictured here very near the x axis at col G first, but Option Gamma is always highest around the Strike price of 12400 and this chart below has it peaking on the right side of the chart and not the left where the 12400 asset price range is?

I deleted the x values in the category label but It doesn't matter which way I go about selecting the x values from the bottom up or top down -- where I get a single data range entry appearing in the category label -- if I green tick it and then go back to look at it it just has 40 single data references set. I don't understand why Apple won't just let you delete them permanently?

Do I have to delete the chart and start over?

I don't understand why simply changing the x axis order and updating the table has caused an issue with wrong facing chart lines, the data is correct in the tables... until you look at the wrong facing charts... and you've spent a whole day getting nowhere! (And you still have 50 odd charts to completely redo since the x axis direction change).

Cheers again ☺️

You do not have to select the data cells one at a time to get the chart to work correctly.

I've had too because Numbers selects the first column as the x axis as a default header for the sheet (eg implied volatility etc in col A). They can either be written in the category labels section as you mentioned or dragged from col A to col G individually. Dragging is easier and that method has has worked well in sheet v12 and now in v13.

It looks like you set the series name to be a cell near the bottom of your column.

Sorry where was this?

You do not need to recreate the charts but it might be easer to start over.

I did, thanks.

But still there was an issue re wrong facing chart curves not respecting a valid data table, but plotting curves back to front. I'm not sure what you mean by messed up, as sheet v12 charts were functioning as intended:

And I have other sheets that have produced high quality accurate Option Greeks charts:

... that is until I reordered the x axis values in col G today, which is why I am a little perplexed... because the only way I can get sheet v13 charts to respect what's in these newly ordered data tables == with the newly reversed x axis -- is to select the relevant column's cells one by one from the bottom -- (in the first image below, I haven't yet finished selecting individual cells all the way to the top, pls recall, the x axis asset prices now ascend from lower to higher values and from bottom to top of the tables) -- because selecting from the top (where a green or blue etc dot appears) and dragging down as one reference means the chart plots incorrectly and back to front despite the table data being double checked and valid. Pls refer to my back to front Gamma chart above where the peak is always near the Strike price (eg 12400) but not in the image above.

Correct facing, Long Call Delta and Gamma Chart (peaking correctly at Strike price 12400):

(only achieved by single cell selection from the bottom of the tables to the top):

Many thanks for the help and suggestions.