Charts removing specific lines, need help

[Zeeb]

i'm using microsoft office 2010, excel, and i were trying to do a chart but a problem occured

\1

the line i outlined in red is it possibel to get it removed without chaning chart type?

[Palmetto]

Yes. Remove that series of data from the chart data source.

[Zeeb]

sorry for being bad at this.. but how? i tried
secound mouse button then selecet data
but if i remove something here it just affects the x,y axisis

i want the numbers to be the same but since the the red/blue area does not reach the line i outlined in red i want the top line removed

[Zeeb]

none knows?

[pike]

cant you just remove that data from the chart??


To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[Andy Pope]

You can not remove individual grid lines. It's all or nothing.
If you want the column stack to reach the top of the plot area set the Y scale maxium to match the value, in your case 2.

[Andy Pope]

You can not remove individual grid lines. It's all or nothing.
If you want the column stack to reach the top of the plot area set the Y scale maxium to match the value, in your case 2.

Quick post window is still double posting I see....

[Zeeb]

You can not remove individual grid lines. It's all or nothing.
If you want the column stack to reach the top of the plot area set the Y scale maxium to match the value, in your case 2.

so if i set the y scale max to 2 it will still show 2,5 just no line there? also where is this done?

so i added a dummy data for you to check out i want the top line to the right of "18" removed but i dont want 18 removed

[Andy Pope]

In that instance then you will need to mask the final grid line with a dummy data series.
You can use either a xy-scatter series with 2 pairs of values.

Or use a line chart series on the secondary axis.
You will need to apply secondary horizontal axis in order to change to cross on tick marks so the line goes from edge to edge.

You need to select the axis and press CTRL+1 to display format dialog.

Example file contains both approaches with the original chart using the line approach and the secondary axis still unformatted so you can see them.

[Zeeb]

sorry for being bad at this andy, but what is "xy-scatter series" and "a line chart series"?

[Andy Pope]

it's the chart type of a specific data series in a chart.
You select 1 of the data series and change it's chart type.