|
Jesus that Consolidate process I'll be telling everyone about  Guess who never has to hack peoples ugly spreadsheets around with Perl anymore.I've got no experience with charts in Excel, and I'm trying to do something that I think is out of the box. Here's a sample of my data:  What I want to do is create a line graph that has on the X axis the numbers 0 through 23 (representing hours of the day, in the HoursOfTheDay column) which may or may not exist in the data (Andrews starts at 6 instead of 0). Y axis should be based on the AVGKPS column. The trick is that I'd like to either create a chart for each value in the Plant column (obviously based on just their data), or if that's not reasonably possible, create a line on each graph that connections each of that Plant's points in a different color, with a key that shows Plant and color or some other way to determine which is which. Is any of this possible out of the box, or is this all VBA funk?
|
#
¿
Jul 20, 2011 17:29
|
|
|
|
| # ¿ May 14, 2024 11:39 |
|
|
Thanks for the help. The data points are so all over the place, that it turns out it only really makes sense if I run this overall instead of breaking it out hourly, which makes charts far less necessary. However, I've learned something
|
|
#
¿
Jul 20, 2011 18:22
|
|