Some chart columns are missing in the Chart View

[Light_newbie]

Hi. I am little stuck on trying to make a chart view to my data. I can select all my chart columns if the Chart Type is histogram, horizontal histogram, aggregate piechart, or aggregate donutchart. But there are only a few columns that can be chosen if I try to use the other types of charts, such as piechart, col series [line] (that is what I want to use), row series. It is about 10 of the columns total and only 4 of them can be selected in the Chart Columns.

The chart columns which I could select are: RowNumber, Battery(Percent), Estimated usage time(Number) and Time spent on Activity(Number).

And the missing chart columns are: Date, Activity(Emun with Ref), Recharge(Yes/No), Actual usage time(Number).

I am wondering if the Date Type of the columns or the setup of the chart are wrong to cause this issue.

Thank you!

[WillowMobileSys]

Please show your data and how you are trying to configure the charts.  We can help better with those details.

[Light_newbie]

Thank you for trying to help me. Do you mean you need the data formula or some examples? It would be simpler if I showed you the screencap of my data; unfortunately, the Data does not use English from the beginning. I tried to put it on a table for easy understanding. Since the space is not enough, I didn't show the full sentence of the formula/initial value. Please let me know and I will put it here if more information is needed.

My current chart setting is:

• For this data: MyWatch
• View type: Chart
• Position: menu
• Chart type: col series [line]
• Chart columns: Battery, Est. usage time

The other options remain unchanged.

The current chart look like this:

I want to add one more important column [Actual usage time] to show the difference between the [Estimated]. But cannot find it in the chart column.

Please feel free to let me know if more information is needed.