If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart oddity
I was trying to make a simple line chart (Excel 2000). I had the following
columns: Date, Heat 05, Air Cond 05, Heat 06, Air Cond 06 all populated with the running time of the furnace or air conditioner up to today's date. The chart would omit the first column of data to the right of the Date column until I deleted the heading "Date" from the Date column. Everything else in the chart appeared normal. Is this normal behaviour or have I stumbled upon a bug of some kind? -- Ron P |
#2
|
|||
|
|||
Chart oddity
I can't envision exactly what was going wrong. But I'll point out that a
not-well-known best practice is to leave the top left cell blank. This helps Excel parse the data range. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Ron P" wrote in message ... I was trying to make a simple line chart (Excel 2000). I had the following columns: Date, Heat 05, Air Cond 05, Heat 06, Air Cond 06 all populated with the running time of the furnace or air conditioner up to today's date. The chart would omit the first column of data to the right of the Date column until I deleted the heading "Date" from the Date column. Everything else in the chart appeared normal. Is this normal behaviour or have I stumbled upon a bug of some kind? -- Ron P |
#3
|
|||
|
|||
Chart oddity
Thanks for the thought. It is a bit strange and something to keep in mind
when charts are going to be used. It had me wondering what I had done wrong with my data seeing that the chart wasn't working out. Thank you. "Jon Peltier" wrote in message ... I can't envision exactly what was going wrong. But I'll point out that a not-well-known best practice is to leave the top left cell blank. This helps Excel parse the data range. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Ron P" wrote in message ... I was trying to make a simple line chart (Excel 2000). I had the following columns: Date, Heat 05, Air Cond 05, Heat 06, Air Cond 06 all populated with the running time of the furnace or air conditioner up to today's date. The chart would omit the first column of data to the right of the Date column until I deleted the heading "Date" from the Date column. Everything else in the chart appeared normal. Is this normal behaviour or have I stumbled upon a bug of some kind? -- Ron P |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pasting chart shows chart area, not the chart | Pirjo | Powerpoint | 3 | October 13th, 2005 04:31 AM |
how to add animation to a chart - make lines appear | David Leonard | Powerpoint | 11 | June 2nd, 2005 12:33 AM |
Urgent Chart Questions | Brent E | General Discussion | 0 | May 9th, 2005 11:01 PM |
Scrollbar on Chart Jumps to Left when Chart is Clicked | Bob | Charts and Charting | 5 | May 1st, 2005 02:06 AM |
build chart template; then add series one by one | L Mehl | Charts and Charting | 2 | February 12th, 2004 10:53 PM |