#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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.
|
|
|