Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Anyone good with excel VBA?
New Posts  All Forums:Forum Nav:

Anyone good with excel VBA?

post #1 of 2
Thread Starter 
Hi, I'm trying to use VBA in Excel that will create graphs for me depending on a selection from a dropdown menu. I have numerous sheets of data, but I want to be able to display the data in graphs on one sheet depending on a choice from the user (from a dropdown menu). All of the graphs will have the same axis, only the data will change (the graphs will update with each choice). Is this possible? Thanks.
McLovin
(13 items)
 
  
CPUMotherboardGraphicsRAM
i5 2500K @4.5ghz 1.26v Asus P8Z68-V PRO GTX 570 Twin Frozr III G.Skill Ripjaws X 2x4Gb 1600mhz 
Hard DriveOSMonitorPower
Crucial M4 64Gb/WD Caviar Black 1Tb Windows 7 64 bit Samsung 2053BW Corsair AX850W 
Case
NZXT Phantom Red 
  hide details  
Reply
McLovin
(13 items)
 
  
CPUMotherboardGraphicsRAM
i5 2500K @4.5ghz 1.26v Asus P8Z68-V PRO GTX 570 Twin Frozr III G.Skill Ripjaws X 2x4Gb 1600mhz 
Hard DriveOSMonitorPower
Crucial M4 64Gb/WD Caviar Black 1Tb Windows 7 64 bit Samsung 2053BW Corsair AX850W 
Case
NZXT Phantom Red 
  hide details  
Reply
post #2 of 2
You don't need VBA to do this.

http://peltiertech.com/Excel/Charts/Dynamics.html
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Anyone good with excel VBA?