ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   change last serie to be line in the line-column Excel chart in Wor (https://www.excelbanter.com/charts-charting-excel/148288-change-last-serie-line-line-column-excel-chart-wor.html)

Eric

change last serie to be line in the line-column Excel chart in Wor
 
Hi, I'd like to insert the Excel chart in Word doc. When I insert an Excel
chart with 4 series in the type of line-column. The second serie always to be
line, I want to the last serie to be line rather than second one. I know how
change it when it happens in Excel. But I cannot find the all of excel Menus
in Word windows when I edit chart in the word, so I donot know how change it?
Thanks a lot for anyone offering help.

ShaneDevenshire

change last serie to be line in the line-column Excel chart in Wor
 
Hi,

That depends on how you copied the chart into word?


--
Thanks,
Shane Devenshire


"Eric" wrote:

Hi, I'd like to insert the Excel chart in Word doc. When I insert an Excel
chart with 4 series in the type of line-column. The second serie always to be
line, I want to the last serie to be line rather than second one. I know how
change it when it happens in Excel. But I cannot find the all of excel Menus
in Word windows when I edit chart in the word, so I donot know how change it?
Thanks a lot for anyone offering help.


Jon Peltier

change last serie to be line in the line-column Excel chart in Wor
 
1. Fix the chart in Excel before moving it to Word.
2. Don't use the built-in custom chart types. Start with all series as
columns, then one by one select each you need to change, and use Chart menu
Chart Type to change it.


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


"Eric" wrote in message
...
Hi, I'd like to insert the Excel chart in Word doc. When I insert an Excel
chart with 4 series in the type of line-column. The second serie always to
be
line, I want to the last serie to be line rather than second one. I know
how
change it when it happens in Excel. But I cannot find the all of excel
Menus
in Word windows when I edit chart in the word, so I donot know how change
it?
Thanks a lot for anyone offering help.




ShaneDevenshire

change last serie to be line in the line-column Excel chart in
 
Hi,

If you copy the chart as a picture you will not be able to modify it in
Word, if you copy it as an Embedded Object (OLE) you can double-click it to
modify it.
--
Cheers,
Shane Devenshire


"ShaneDevenshire" wrote:

Hi,

That depends on how you copied the chart into word?


--
Thanks,
Shane Devenshire


"Eric" wrote:

Hi, I'd like to insert the Excel chart in Word doc. When I insert an Excel
chart with 4 series in the type of line-column. The second serie always to be
line, I want to the last serie to be line rather than second one. I know how
change it when it happens in Excel. But I cannot find the all of excel Menus
in Word windows when I edit chart in the word, so I donot know how change it?
Thanks a lot for anyone offering help.



All times are GMT +1. The time now is 08:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com