0

I am trying to create a dynamical line graph chart with multiple line graphs on the chart.

For example, I want to be able to graph this data, where each PADD will be its own chart, and on each of these charts, the lines will consist of the different companies, the x-axis is the date, and the y-axis is the FSC%. Here is an example of the data:

enter image description here

I want the graphs to be able to automatically update as soon as new data comes in. I know I'll need my data to be in a table format and not in a range. Most videos online show people using "Recommended Charts", and they are able to find their chart that way, but whenever I do that, the results look absurd.

Any idea how I might be able to do this?

Improve this question
2
  • Start by rearranging the data so that each PADD is its own column and each date its own row, then generate a chart from that
    – cybernetic.nomad
    Commented Jul 10, 2023 at 15:22
  • @cybernetic.nomad, that worked, but now I'll have to restructure my query so a chart can be automatically formulated, which might be a hassel. But thank you for your help.
    – anon1212
    Commented Jul 10, 2023 at 15:43

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .