Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jan
 
Posts: n/a
Default gap width zero - double line

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
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default gap width zero - double line

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



  #3   Report Post  
Posted to microsoft.public.excel.charting
Jan
 
Posts: n/a
Default gap width zero - double line

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




  #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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why double click on row line moves me on the end of sheet? Marek Zitnansky Excel Discussion (Misc queries) 1 December 28th 05 04:23 PM
format data series line width default NoelH Charts and Charting in Excel 4 November 3rd 05 03:51 AM
Is there a double dashed line in Draw to be imported? Anna M. New Users to Excel 2 October 14th 05 09:37 AM
double line spacing using excel 2000 Dan Excel Discussion (Misc queries) 8 March 22nd 05 01:33 PM
How can I set the default line width HighPlanes Charts and Charting in Excel 3 December 3rd 04 06:21 AM


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"