I want to plot data down through sheets in stead of within a sheet. Quattro
Pro allowed me to do this but can't figure how to do it in Excel
I want to plot data down through sheets in stead of within a sheet. Quattro
Pro allowed me to do this but can't figure how to do it in Excel
MooseTrax,
You can chart non-contiguous ranges within a worksheet but not between
sheets. Probably the best option is to create linked cells on a "master"
sheet to your other sheets and then create the chart based on the data on the
master sheet.
----
Regards,
John Mansfield
http://www.pdbook.com
"MooseTrax" wrote:
> I want to plot data down through sheets in stead of within a sheet. Quattro
> Pro allowed me to do this but can't figure how to do it in Excel
This page may help explain how to set up a summary 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/
_______
MooseTrax wrote:
> I want to plot data down through sheets in stead of within a sheet. Quattro
> Pro allowed me to do this but can't figure how to do it in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks