Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change graphic chart properties
I created a Graphic Chart in Excel, part of this chart is in bars and part is
in lines. I changed the chart type for one of this values, from line to bar. When I clicked Ok, this new bar added is wider than the others. What can I do to make this new bar be like the other bars in the graphic chart?? I tried to change the wide, but it affects all the bars. Thanks in advance for your information. Eduardo Gonzalez. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change graphic chart properties
Depends which version of Excel that you are using - in 2003 right click on
the bar select options and you can manipaulate the bar and spcing as required. The site below is very good for graphing http://peltiertech.com/index.html edvvw Israel wrote: I created a Graphic Chart in Excel, part of this chart is in bars and part is in lines. I changed the chart type for one of this values, from line to bar. When I clicked Ok, this new bar added is wider than the others. What can I do to make this new bar be like the other bars in the graphic chart?? I tried to change the wide, but it affects all the bars. Thanks in advance for your information. Eduardo Gonzalez. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change graphic chart properties
thanks for your answer.
I have Office 2003. I right clicked and change properties for the chart, but when I change the wide for this bar, the rest of the bars also increase or decrease the wide size, and I want all the bar to have the same wide. Is it possible or maybe I'm making something wrong? thank you "edvwvw via OfficeKB.com" wrote: Depends which version of Excel that you are using - in 2003 right click on the bar select options and you can manipaulate the bar and spcing as required. The site below is very good for graphing http://peltiertech.com/index.html edvvw Israel wrote: I created a Graphic Chart in Excel, part of this chart is in bars and part is in lines. I changed the chart type for one of this values, from line to bar. When I clicked Ok, this new bar added is wider than the others. What can I do to make this new bar be like the other bars in the graphic chart?? I tried to change the wide, but it affects all the bars. Thanks in advance for your information. Eduardo Gonzalez. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change graphic chart properties
I suspect you started with the columns and lines on different axes custom
type. Changing a line to a column means your new column is on the secondary axis, and the other columns are on the primary. To ensure all the columns use similar spacing, you need to move the secondary column to the primary axis: double click on it, and on the Axis tab, choose Primary. Next time, you don't need to use the custom built-in types, just make a column chart, then select any you want to change, and use Chart menu Chart Type to change it. Then double click on any series and go to the Axis tab to change to the secondary axis if needed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Israel" wrote in message ... thanks for your answer. I have Office 2003. I right clicked and change properties for the chart, but when I change the wide for this bar, the rest of the bars also increase or decrease the wide size, and I want all the bar to have the same wide. Is it possible or maybe I'm making something wrong? thank you "edvwvw via OfficeKB.com" wrote: Depends which version of Excel that you are using - in 2003 right click on the bar select options and you can manipaulate the bar and spcing as required. The site below is very good for graphing http://peltiertech.com/index.html edvvw Israel wrote: I created a Graphic Chart in Excel, part of this chart is in bars and part is in lines. I changed the chart type for one of this values, from line to bar. When I clicked Ok, this new bar added is wider than the others. What can I do to make this new bar be like the other bars in the graphic chart?? I tried to change the wide, but it affects all the bars. Thanks in advance for your information. Eduardo Gonzalez. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change properties for all new documents in Excel? | Excel Discussion (Misc queries) | |||
What is a relationship magnitude graphic chart | Charts and Charting in Excel | |||
change control properties according to a cell value | Excel Worksheet Functions | |||
Change Cell properties by Function | Excel Worksheet Functions | |||
No void value skipped by graphic chart | Charts and Charting in Excel |