ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Line chart based on 3 columns (https://www.excelbanter.com/excel-worksheet-functions/447988-line-chart-based-3-columns.html)

galkas

Line chart based on 3 columns
 
Hello
I'd like to create a line chart based on 3 columns. Column 1 is X axe, columns number 2 and 3 are lines. Excel wizard creates chart with 3 lines. It should be dead simple, but I cannot find/remember how to do it. Any help will be appreciated. Galina

Spencer101

1 Attachment(s)
Quote:

Originally Posted by galkas (Post 1608628)
Hello
I'd like to create a line chart based on 3 columns. Column 1 is X axe, columns number 2 and 3 are lines. Excel wizard creates chart with 3 lines. It should be dead simple, but I cannot find/remember how to do it. Any help will be appreciated. Galina

Could you attach an example of what you have so far so we can see where it's going wrong?

I've just created a rough 3 column data set and Excel creates a 2 line graph from it with no problem, using the first column as the X axis. (see attached)


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com