Forum Discussion
meaganmaguire
Aug 20, 2024Copper Contributor
Is plotting 2 columns of data on one line possible?
I am trying to reproduce a visual that I created before, however, the formatting of my data has been requested to be streamlined and easier for automatic updates. My original data and visual looked l...
m_tarler
Aug 21, 2024Bronze Contributor
meaganmaguire I would use a couple of helper columns and then use the opportunity to create Names for those columns so the plot will automatically update. I also 'Formatted as Table' the orginal data table and called it Data
so the year column would be:
=TOCOL(HSTACK(Data[Date],Data[Date]))and the Specific Capacity is:
=TOCOL(Data[[SCi]:[SCf]])Then in the Names section I defined:
Plot_Year = 'Plot data'!$A$2#
Plot_SpecCapacity = 'Plot data'!$B$2#
then the plot uses those names