Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel Charts!!

Excel Charts!!

Excel Charts!!

Heloo All:
I have got 20 sheets in an excel file.Now for the first sheet say "A" i have drawn various charts(20 in no.) in series.
For the remaining 19 sheets i need to draw again 20 charts
for each sheet.The cell nos. for both "x" and "y" axis are the same as for the 20 charts already drawn for sheet "A".
Can you suggest any methos wherein i don't have to select the cells each time corresponding to "x" axis, "y" axis and give a relevant code as the cell nos. for 20 charts in each sheet are the same as for the cell nos. of the 20 charts in sheet "A" which are already drawn.
Please help

RE: Excel Charts!!

One way to do it:

select the tab for sheet "A" at the bottom of the screen.  Right click and choose "move or copy."  Select "move to end" and check the "make a copy" box.  This will make an exact duplicate of sheet "A", but with a slightly different name.  Now select all your data from sheet "B" and copy it.  Paste this data over the data in the copy of "A".  Now you can delete "B" and rename the copy of "A" to "B".

RE: Excel Charts!!

Thanks very much!!!Good idea, never striked me!!

RE: Excel Charts!!

ivymike and Excel doubt,
i agree and support with what ivymike recommended, with one matter that needs to be checked.  from my recollection, when copying and pasting data, like you've mention, into an already established chart, use the paste special feature and paste the values only or formulas only.   i seem to recollect doing the same thing, but when pasting data, the chart series data source needed to be re-established - a royal pain...
apparently when pasting data, the chart looks for data in a certain area and when pasting data over existing chart data series references, it fouls up.  something to be aware of.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close