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
Please reply to this thread with any new information or opinions.

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 12:24 PM


All times are GMT -7. The time now is 10:50 PM.


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