Two Plus Two Newer Archives  

Go Back   Two Plus Two Newer Archives > Other Topics > Computer Technical Help
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2007, 03:54 AM
jzpiano jzpiano is offline
Senior Member
 
Join Date: Oct 2004
Location: IL
Posts: 2,385
Default Excel Help

I'm trying to get a graph in microsoft excel to work I need column G in the X axis. Here is the tricky part, I want column H in Y axis. I want them each in an individual line graph with new lines being added or subtracted if the previous or following cell has more or less numbers. I've tried to draw it as best I could in paint.

See how the first number of first 6 boxes is its own line with a shading below it (the red area). Then the second number of each of the first six boxes is added on to the previous area (the red area) and now becomes the blue area.
Hope this is enough to help understand what I'm trying to do. Ideally I don't want to switch the cells of column H because it is specific to music I'm trying to analyze. Let me know if this is possible or if more clarification is needed.

Reply With Quote
  #2  
Old 01-17-2007, 05:33 AM
BeaucoupFish BeaucoupFish is offline
Senior Member
 
Join Date: Jun 2005
Location: San Francisco
Posts: 723
Default Re: Excel Help

I would think you would need to separate out the notes into separate columns before you can do anything. Then you could add or subtract these in additional columns, and use those for the graphing.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.