Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Graphical display of data from different sheet

Status
Not open for further replies.
AMS100

AMS100

Programmer
Oct 19, 2001
111
GB
Hi, I have an excel document - I would like to present the info in the form of graphs - the data is in sheet 1 and I would like the graphs to be in sheet 2 - how do I do this??
Thanks
 
Sort by date Sort by votes

Hi,

Create the CHART on the sheet containing the source data and then move it to any other sheet using the Chart Location property.

Skip,

[glasses] [red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it![tongue]
 
Upvote 0 Downvote
Great thanks - I new it would be simple - cheers
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
979
bs6600
bs6600
techguy2010
  • Locked
  • Question
Excel macro to send e-mail to multiple agents with a different body for each 1
Replies
3
Views
776
techguy2010
techguy2010
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
577
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
521
SkipVought
S
rk68
  • Locked
  • Question
matching data from one excel sheet to another
Replies
6
Views
400
rk68
rk68

Part and Inventory Search

Sponsor

Back
Top