View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default gap width zero - double line

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/
_______


"Jan" wrote in message
...
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" wrote:

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
_______


"Jan" wrote in message
...
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