4 Replies Latest reply on Jun 27, 2018 10:53 AM by Jim Dehner

    Question regarding chart making and data source set up?

    Bo Gil

      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,