Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,670
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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.



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
Change line to bar in Line - Column graph Yonke Charts and Charting in Excel 4 January 16th 07 12:42 AM
How to add a Vertical Line to a Column or Line Chart with two axes already in use? Alan Charts and Charting in Excel 6 December 13th 06 03:37 AM
Chart Type - Line Column adding a 2nd line [email protected] Charts and Charting in Excel 1 October 24th 06 04:17 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
How do I change column into lines on a Line-Column chart? Ken Charts and Charting in Excel 1 March 17th 05 02:29 PM


All times are GMT +1. The time now is 02:03 PM.

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

About Us

"It's about Microsoft Excel"