Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change workbook
I have a populated chart in one workbook. I want to make the same chart in
another workbook (with different data but with same chart settings eg. line style). Is it possible to somehow copy the chart from one workbook to another and then just change the data series? I tried that but my chart now has ugly grey lines all over it (dont know what they mean but they are diagonal). Please need help! Thanks alot! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change workbook
You may have better results if you copy the entire sheet, including both
chart and data, then replace the copied data with the data from the other sheet you want to plot. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Arne Hegefors" wrote in message ... I have a populated chart in one workbook. I want to make the same chart in another workbook (with different data but with same chart settings eg. line style). Is it possible to somehow copy the chart from one workbook to another and then just change the data series? I tried that but my chart now has ugly grey lines all over it (dont know what they mean but they are diagonal). Please need help! Thanks alot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
Change Excel default Workbook Template? | Excel Worksheet Functions | |||
When sharing a workbook unable to change color of tabs | Excel Discussion (Misc queries) | |||
Find function | Excel Worksheet Functions | |||
change a function in a workbook without changing every cell | Excel Worksheet Functions |