Answered

Creating line chart from textinput values

(0) Share

Report

Posted on by jayvee

Festive greetings.

Was hoping someone knew how to create a line chart using data entered in the textinput boxes directly in the app (no external data sources). I was thinking the below, but this only creates 1 series in the chart, I need multiple. Any ideas?

Table({Value:TextInput1.Text, Label: "Category1"},{Value:TextInput2.Text, Label: "Category2"})

Essentially I need a line chart to show below with year as the x axis and sales on the y axis - with 2 lines for each machine

Machine 1	Machine 2	Year
350	520	2016
100	200	2017

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

jayvee 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, re. last sentence - I mean 1 line for each machine

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried changing the Number of Series to of the Chart to 2?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
jayvee 22 on at

Like
a
(0)

Report
Copy link

Link copied!

YEs, the number of series is set to 2 on the chart. THe issue is with the formula above I think - it doesn't distinguish between sets of data - it just considers it as 1 series.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@jayvee

I am not sure of your connection between the sample formula you provided and the sample data you provided. One specifies Categories and the other shows machines and years.

But, if I go by the sample data, you would need to get your formula to something like this:

Table({Year:"2016", Machine1:350, Machine2:520}, {Year:"2017", Machine1:100, Machine2:200})

Then, set series count to 2 (which you state you have). Then Labels set to Year and Series1 to Machine1 and Series2 to Machine 2.

This will give you two series lines based on those values.

I hope this is helpful for you.

Was this reply helpful? Yes No
jayvee 22 on at

Like
a
(1)

Report
Copy link

Link copied!

Amazing, many thanks RandyHayes!

Was this reply helpful? Yes No