Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why double click on row line moves me on the end of sheet? | Excel Discussion (Misc queries) | |||
format data series line width default | Charts and Charting in Excel | |||
Is there a double dashed line in Draw to be imported? | New Users to Excel | |||
double line spacing using excel 2000 | Excel Discussion (Misc queries) | |||
How can I set the default line width | Charts and Charting in Excel |