Is it possible to make a line chart with the way I have my data source set up as is? The source is just a excel flat file and I do not feel like manipulating it to the point of absurdity. All I am trying to do is basically show my profit center's on the y-axis, or rows, and months on the x-axis, or columns. Basically a line connecting the monthly data within the location, and not by location within a single month.
I have a feeling that I will have to add a date field for the months to the data itself or somehow share the y-axis (profit center) with the values.
I am working with version 10.5.whatever.
Thank you,
Like this
all you have to do is pivot the data - Pivot Data from Columns to Rows
your workbook is attached
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
