Ideal ranges in excel charts?
October 11, 2012 11:13 PM Subscribe
Displaying ideal ranges in the plot area of an Excel 2007 chart. Possible?
posted by xyzzy to Computers & Internet (2 answers total) 4 users marked this as a favorite
Say I have a table in a worksheet that tracks temperature data. The table is like this:
Day | Temp (F)
Day is plotted on X, of course, and temp on Y.
I'd like to create a chart that has two components: an actual line showing daily recorded temperatures, and a filled in area behind that line that displays an ideal temperature range.
I know I can do conditional formatting in the table itself, but I'd really like the ideal range to be displayed handily in the plot area of a chart. I assumed I could do this using a secondary axis, but I'm rather stumped as to how this might be accomplished. It seems like this would be a common thing people would like to do, but no amount of googling has revealed a method to accomplish this.
If Excel 2007 can't do this, is there another spreadsheet program (preferably free) that can do this? Can Excel 2010 do this? Or is there something I could export the CSV data into that would allow this type of visualization? Preferably without needing to write code. I can write code. I don't want to.