Forum Discussion

meaganmaguire's avatar
meaganmaguire
Copper Contributor
Aug 20, 2024

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 like this:

Now my data must look somewhat like this where an initial and final value are together on one row instead of separate rows. Will it even be possible to reproduce the visual? The only way I can imagine it working is if Excel reads in a zigzag way down C and D.

 

 

 

Charting
excel
Formulas and Functions

1 Reply

Sort By
  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Aug 21, 2024

    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

Resources