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
|
|||
|
|||
vertical line chart
I need plot readings for 2 different meters for 31 days so that my lines in
the line chart go vertically. Is this possible? Please help |
#2
|
|||
|
|||
vertical line chart
Make an XY chart, with the date for Y and the meter readings for X. Make the
chart with one series, then copy the second set of data, select the chart, and use Paste Special from the Edit menu to paste the data as a new series. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Larissa" wrote in message ... I need plot readings for 2 different meters for 31 days so that my lines in the line chart go vertically. Is this possible? Please help |
#3
|
|||
|
|||
vertical line chart
Thank you Jon, it did not work the way you have outlined it, but combined
with my visit to your website yesterday it gave food for thought and I just did it the following way: I highlighted all 3 colums of data, went to chart wizard, chose scatter chart, and then is step 2 of wizard specified what data for both series should be treated as x, what data should be treated as y and what should be treated as names of series. From that point on it was a matter of setting the scale for axis x correctly to see exactly what I intended to appear on the chart. Great stuff, now I am thinking outside the box. Larissa "Jon Peltier" wrote: Make an XY chart, with the date for Y and the meter readings for X. Make the chart with one series, then copy the second set of data, select the chart, and use Paste Special from the Edit menu to paste the data as a new series. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Larissa" wrote in message ... I need plot readings for 2 different meters for 31 days so that my lines in the line chart go vertically. Is this possible? Please help |
#4
|
|||
|
|||
vertical line chart
Hi Larissa -
Great stuff, now I am thinking outside the box. Best place to be. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Larissa" wrote in message news Thank you Jon, it did not work the way you have outlined it, but combined with my visit to your website yesterday it gave food for thought and I just did it the following way: I highlighted all 3 colums of data, went to chart wizard, chose scatter chart, and then is step 2 of wizard specified what data for both series should be treated as x, what data should be treated as y and what should be treated as names of series. From that point on it was a matter of setting the scale for axis x correctly to see exactly what I intended to appear on the chart. Great stuff, now I am thinking outside the box. Larissa "Jon Peltier" wrote: Make an XY chart, with the date for Y and the meter readings for X. Make the chart with one series, then copy the second set of data, select the chart, and use Paste Special from the Edit menu to paste the data as a new series. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Larissa" wrote in message ... I need plot readings for 2 different meters for 31 days so that my lines in the line chart go vertically. Is this possible? Please help |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Vertical line--leaving line and losing the box | Chad Harris | New Users | 1 | February 1st, 2005 04:50 AM |
Conditional Chartting | Os | Charts and Charting | 14 | October 16th, 2004 01:12 PM |
vertical line in graph | Jack Sons | General Discussion | 1 | August 15th, 2004 06:39 PM |
cumulative line chart problems | neowok | Charts and Charting | 3 | June 22nd, 2004 02:52 AM |
Plotting a datapoint on an existing Line chart | Tushar Mehta | Charts and Charting | 0 | November 23rd, 2003 01:08 AM |