Turn off difference fill between lines in lien graph

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
This is a guess, but I think the black "fill" is just the tightly packed markers for each data point. Is your data hundreds of data points for both lines and the values for each line are close to each other?

Maybe you could create a line chart without the data point markers (just the lines). Or you could reduce your data frequency. For display purposes, you might want to chart say every 10th data point or something like that.
 
Upvote 0
Hi, AlphaFrog.

i've checked the graph but it isn't tightly packed markers.
There are only two lines in the graph for the link I've given from above.

However, I have solved the problem. I had High-Low lines enabled.
All I needed to do was right click on the black area and click delete... (doh!)

I dunno where that high-low line came from..
Where can I find it?

Thank you for your help!
KPark
 
Upvote 0

Forum statistics

Threads
1,224,604
Messages
6,179,857
Members
452,948
Latest member
UsmanAli786

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top