gap width zero - double line

[Guest]

I want a bar chart with gap zero.
When I set gap width to zero and the border of the bar to single line, then
the border between two bars is shown as double. I don't like the visual
appearance of this.
I am rewriting a word-app to an excel app and the point is that the same
barchart is shown in Word with a single line between to charts (that means
that the borders of two adjacing bars overlap each other. I want the same
behaviour in Excel but I don't get it. Why this inconsistency? Is there a
workaround?

Jan

 

[Jon Peltier]

If the chart with the apparent double line is copied as a picture, the
picture of the chart has a single line. If you subsequently copy/paste the
chart to another app, use Copy Picture instead of Copy, and you will have
acceptable results.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

 

[Guest]

The point is that I don't like the way the graph is shown in Excel. I want
all the borders around the bars shown as a single line, also between the bars
and at the bottom of the bar. Look at the examples in
http://www.lerenmetcomputers.nl/temp/graphinexcel.html
the first picture shows the graph the as it is in Excel. The second picture
shows the graph like I want it to look. I don't know how to change the
settings in Excel to achieve this. With gaph widt = 0 I get the result that
is shown in the first picture.
Very strange is that the bottom line for all colums is shown as double,
except for that of colum 4.

Jan

 

[Jon Peltier]

Implicit in my response is the phrase "You can't get it to look that way in
Excel." The ancient graphic algorithms don't appropriately overlap all the
edges.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______