Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Keith
 
Posts: n/a
Default How do I chart the same data cell on a range of worksheets?

I have the same row of cells on numerous worksheets that I want to chart or
consolidate onto another worksheet ?
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Keith -

You need to create a consolidated data range:

http://peltiertech.com/Excel/ChartsH...iffSheets.html

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

Keith wrote:

I have the same row of cells on numerous worksheets that I want to chart or
consolidate onto another worksheet ?


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
Stock High-Low-Close Chart Tim Charts and Charting in Excel 7 August 24th 07 01:02 PM
Excel 2002 chart does not update when worksheet data changes proquant Charts and Charting in Excel 1 June 15th 05 12:23 AM
Add data to cell w/o loosing initial data jaycain Excel Discussion (Misc queries) 2 March 29th 05 02:23 AM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 11:02 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"