Elliot B. Posted August 23, 2016 Share Posted August 23, 2016 However, it doesn't seem to be working: Any idea what I'm doing wrong? Link to comment Share on other sites More sharing options...
0 +Gary7 Subscriber² Posted August 23, 2016 Subscriber² Share Posted August 23, 2016 What program are you using? Link to comment Share on other sites More sharing options...
0 Draconian Guppy Posted August 23, 2016 Share Posted August 23, 2016 Shouldnt pf1 and pj57, be selected individually? Victor Rambo 1 Share Link to comment Share on other sites More sharing options...
0 Elliot B. Posted August 23, 2016 Author Share Posted August 23, 2016 (edited) 2 minutes ago, Gary7 said: What program are you using? Microsoft Excel 2016. Link to comment Share on other sites More sharing options...
0 +Gary7 Subscriber² Posted August 23, 2016 Subscriber² Share Posted August 23, 2016 I think that you can make two separate graphs using different colors save them both and then merge them. Link to comment Share on other sites More sharing options...
0 zhangm Supervisor Posted August 23, 2016 Supervisor Share Posted August 23, 2016 I can kind of get the lines plotted, but I'm running into a formatting issue. I've formatted the Date column as dates rather than "General" or "Text". Issue that I'm seeing is that the x-axis labels are not playing nice but this may be a bug in my version of Excel. https://1drv.ms/u/s!Aun4k9xxGD75ivo5POceA1xHkUv5Vw Link to comment Share on other sites More sharing options...
0 c.grz Posted August 23, 2016 Share Posted August 23, 2016 (edited) Edited August 23, 2016 by c.grz Link to comment Share on other sites More sharing options...
0 +BudMan MVC Posted August 26, 2016 MVC Share Posted August 26, 2016 Select the chart, and right click anywhere within the chart. Click Select Data and then click Hidden and Empty Cells. Click to select Connect data points with line, and then Press OK twice. Elliot B. 1 Share Link to comment Share on other sites More sharing options...
0 Elliot B. Posted August 26, 2016 Author Share Posted August 26, 2016 15 hours ago, BudMan said: Select the chart, and right click anywhere within the chart. Click Select Data and then click Hidden and Empty Cells. Click to select Connect data points with line, and then Press OK twice. This is my man, right here! Link to comment Share on other sites More sharing options...
0 +BudMan MVC Posted August 26, 2016 MVC Share Posted August 26, 2016 Did I win the cookie? heheh glad could be of help.. Your other option would be to use 2 different x axis so that your data points do not have gaps in them.. Link to comment Share on other sites More sharing options...
Question
Elliot B.
However, it doesn't seem to be working:
Any idea what I'm doing wrong?
Link to comment
Share on other sites
9 answers to this question
Recommended Posts