I have a music database for my playlists. I have attached a sample file.
I would greatly appreciate any help with my latest project: For each playlist file, I want to insert a new sheet and create a line graph from data on the original sheet.
I am very inexperienced with charts. When I first looked, it seemed as though Excel might not allow using data from a different sheet, but that is probably just my inability to see what it wants . . .
The data to be charted is in columns F and H. I would like F to be the X value, and H for Y. The X axis should intersect the Y axis at ((H1)-2). The F values are in minutes.seconds.
Thanks, again, for any and all help and suggestions.
I would greatly appreciate any help with my latest project: For each playlist file, I want to insert a new sheet and create a line graph from data on the original sheet.
I am very inexperienced with charts. When I first looked, it seemed as though Excel might not allow using data from a different sheet, but that is probably just my inability to see what it wants . . .
The data to be charted is in columns F and H. I would like F to be the X value, and H for Y. The X axis should intersect the Y axis at ((H1)-2). The F values are in minutes.seconds.
Thanks, again, for any and all help and suggestions.