Hello Everyone,
I am new in chart. I have attached a file here. I need to use a line chart to show Growth Performance on column E, I and M for all products. Is it possible since the columns are apart?
I would very much appropriate any suggestions.
Thanks.
Jackson
Last edited by jackson_hollon; 08-13-2016 at 03:46 PM.
See attached. Just select the columns using the Control and mouse button to select separated cells
Happy with my advice? Click on the * reputation button below
Crooza,
Thanks for the reply. Sorry maybe I didn't make my question clearer. I need to have 3 things on the chart. The year, the performance, and the product names. Since the yearly performances are in column E, I and M. How can i select the data as they are apart in the table?
Thanks again for the help.
Jackson
Last edited by jackson_hollon; 08-08-2016 at 08:52 PM.
Sorry I don't follow. Did use the example I posted?based on the example I posted would you like changed?
Crooza,
I am new to the chart thing. This is my first chart. Therefore i may be asking very stupid question. I need the chart to show the year 2016, 2017 and 2018 in the label (X) . And 6 products (6 lines) with product names (you only have 3 lines now for the years, and the products are in the X now), and the performances on Y (it is correct in the chair you provided). I hope I am making it clearer now.
Thanks again for the help.
Jackson
Using Crooza's example
Use Switch Row/Column to get products as series. The Select Data to update range used for horizontal axis.
Andy,
This is exactly what I am looking for. I do not know how to do chart at all. Thanks for the help.
Jackson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks