I think I found a bug in Microsoft Excel 2013. It is not a major bug, but annoying like most bugs.
Do you see the same thing when you try it on your machine?
Do you see it in other versions of Excel?
Let me know in the comments below.
The Bug
When changing the border formatting on a chart data series from Automatic to No Line, Excel changes the formatting option to a Solid Line.
Steps to Recreate
1) Create a Clustered Column Chart
2) Select a data series in the chart and press CTRL+1 to bring up the Format Data Series Dialog box.
3) Select the Fill and Line options menu
4) Change the Border to No Line
5) Notice that Excel changes your selection to Solid Line
Video Demonstration
This embedded resource is unavailable in the restored edition.
What other bugs have you found in Excel? Let me know in the comments below as well.
Steve=True
Reader discussion
Comments preserved from the original page. New comments are closed.
Reader
October 30, 2014 At 8:00 pm
I only looked at 2013.
I may be wrong, but “Automatic” by default appears to be no line. If that is true, then there is no reason to go from “Automatic” to “No line”. Excel assumes that if you don’t want the default of no line, there is no reason to choose “No line”, so it picks “Solid line”.
Reader
November 3, 2014 At 9:12 am
Thanks Don. I am not sure why, but I was changing it for some reason 🙂 I think Excel should let me choose what I want, not guess 🙂 It appears that this was different in Excel 2010