Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-24-2006, 10:26 AM
Novice
 
Join Date: Jun 2006
Posts: 2
jerryjaysr
Default Graphing in Excel - one plot many columns/pick one column

I have a 10meg file with data on 10 separate tabs. Each tab or sheet has about 5-10 graphs.
Data is column 1: date, Column 2 through .. is data (numbers)

Goal is to reduce the size and have a nicer way to graph. I can graph every combination and have hyperlinks to each one but that may take alot of time and a very large file. Would be over 50meg when done. I have data (dates, density, viscosity, weights, etc all vs dates on each sheet)

Would I would like to do is have a few columns with labels and have one graph. So if I selected one column (that would be the x , usually always date, and if I selected the other column that would be the y1 and y2 ). I was hoping to make a list of all columns from all tabs (sheets) then make label for each label in a pull down menu. So I would need the same data or labels (which would refer me to a set of data) for 3 columns. I will always be plotting date vs y or date vs. y1,y2. I see this a lot of times on the internet so I know it can be done.

So instead of having hundreds of graphs I could only have one interactive graph. I have use excel a lot and even have SPC graphs. But would be very nice to be able to plot anything quickly on one plot and to auto scale them. I know we did this years ago on Labview and worked great but all the data is already in Excel and would like to use #Excel for it. Our customer is using jump and mintab.
So all I want to do is pick or cliok onto a label which represents a column of data on a certain sheet then graph it vs another one all vs time (date). Then would be very nice to have buttons allowing me to change labels/scaling, etc..



Is this something Excel can do. I was considering looking into Labview again for this but wanted to keep it simple.

Some of the columns are blank and some have notes and data.

I have the excel file if anyone would like to look at it.

Please feel to email at here:
jerryjaysr@yahoo.com or jerry.jernigan@bp.com

thank you - Jerry
Reply With Quote
  #2  
Old 06-26-2006, 07:41 AM
Novice
 
Join Date: Jan 2006
Posts: 9
adbarnes
Default Try this link.

Here are some examples for dynamic/interactive charts. see if it helps. http://peltiertech.com/Excel/Charts/Dynamics.html
Reply With Quote
  #3  
Old 06-26-2006, 10:55 AM
Novice
 
Join Date: Jun 2006
Posts: 2
jerryjaysr
Default Thank you

I have used it as an example and added alot of data and things.....

It works very nicely. Spent several hrts on it already.

Can I post my work and then ask a simple quesiton. I was wondering if I could add some kind of button to control the scaling and x axis (dates) without going into the chart properties itself.
I am doing x,y,y and looks good except scaling

Jerry
Reply With Quote
  #4  
Old 06-29-2006, 07:15 AM
Novice
 
Join Date: Jan 2006
Posts: 9
adbarnes
Default You may be able to:

This may help you in your quest to be able to do the dates. not sure about the scale.

http://www.peltiertech.com/Excel/Cha...micLast12.html

This will create a slider with offsets to be able to change a date range on one axis.

HTH.
Reply With Quote
  #5  
Old 06-29-2006, 07:27 AM
Novice
 
Join Date: Jan 2006
Posts: 9
adbarnes
Default Wrong Link

This is the link for the scrolling data chart.

http://www.andypope.info/charts/Scrolling.htm
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
From Excel column to coma saatfj Excel 2 04-15-2010 09:59 PM
How do i get my text in columns straight and inline in word 2007? terrasaw Word 0 09-03-2008 06:00 AM
Conditional Formatting to Hide Rows or Columns? sczegus Excel 0 09-26-2006 04:17 PM
SUMMING TWO COLUMNS LOGISTICS1 Excel 1 04-18-2006 06:00 AM
Having your cake and graphing it to! Ziegemon Excel 0 03-21-2006 01:24 PM


All times are GMT -7. The time now is 10:44 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft