2 Replies Latest reply on Oct 28, 2013 6:34 PM by Michael Cristiani

    Charting from two worksheets

    Sharon Foo

      Hi there, does anyone know if you can create a chart using values from two worksheets within the same workbook? I am trying to keep the 100% of a measure constant and show the contribution of selected fields on a bar chart or similar.

        • 1. Re: Charting from two worksheets
          Tracy Rodgers

          Hi Sharon,

           

          Not sure if you still need assistance on this. However, typically it's not possible to chart values from two different worksheets. Depending on what you're trying to do exactly, filters could be put in place on each sheet individually and not on the third. If you're able to post a packaged workbook (twbx file) I might be able to help you further.

           

          -Tracy

          • 2. Re: Charting from two worksheets
            Michael Cristiani

            Shanon,

             

            Are you wanting to chart values from two Excel worksheet data sources in the sane Excel workbook, or from two Tabeau worksheets within the same Tableau Workbook?  Depending on what you want to do, the approach is a bit different.

             

            Looking forward to hearing from you here.

             

            Michael.