How to create multiple charts in one sheet?

0 votes
How to create multiple charts in one sheet?. Can we create multiple charts in the same sheet?
May 22, 2019 in Tableau by Karthick
6,852 views

3 answers to this question.

0 votes

Hi,

You can create multiple charts in a sheet but there are limitations on the charts that can be put in the same sheet.

For Ex: Below is a chart, that contains an area chart, bar chart, and line chart,

You can create charts with one column and multiple rows ot the vice versa.

Using common or relative column and rows would provide you better visualizing multi[ple charts.

Multiple charts in a sheet are created using 1 common field and other dimension or measure as per choice.

Hope it helps.

answered May 22, 2019 by Cherukuri
• 32,460 points
0 votes

Thanks for your question 

 Click an empty cell, and press [F11].
Change the default chart name to Two Chart Sheet.
Select the first chart you want to move to the chart sheet, and go to Chart. | ...
Select As Object In, and choose Two Chart Sheet from the drop-down list.
Click OK.
Repeat Steps 3 through 5 for the second chart you want to move.

or 

instead of selecting a chart, select the range of cells containing the
charts you want to print, or
- select one chart, then hold down the Ctrl key while you select the others
that you want to plot.
Since Excel still defines a rectangular print range if you use the second
the method, you might find that some charts print that you did not select.
However, by re-arranging them and/or playing around a bit (with scaling, page
breaks, etc.), you should be able to get what you want.

answered Jun 7, 2019 by ruhhana
Thanks, Ruhhana

But the steps you gave is for Excel, it is not possible with tableau?

Can you help regarding the same with Tableau?
0 votes

Hi,

You can place more than one chart on a chart sheet. For example, let's say you have two charts on two different worksheets, and you want to put them both on a single chart sheet for comparison and printing.

Follow these steps:

  1. Click an empty cell, and press [F11].
  2. Change the default chart name to Two Chart Sheet.
  3. Select the first chart you want to move to the chart sheet, and go to Chart | Location.
  4. Select As Object In, and choose Two Chart Sheet from the drop-down list.
  5. Click OK.
  6. Repeat Steps 3 through 5 for the second chart you want to move.

 However, You can move as many charts as you can fit. Go to View | Sized With Window to scale the charts to the window.

answered Jun 6 by anonymous
• 140 points

edited Jun 8 by Gitika

Related Questions In Tableau

0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
4,673 views
0 votes
1 answer

How can I create a second sheet which is filtered to 8 days ago,

Following are the steps you can follow: Create ...READ MORE

answered Jul 11, 2018 in Tableau by Atul
• 5,530 points
135 views
0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by Atul
• 5,530 points
118 views
0 votes
1 answer

How to aggregate multiple column in Tableau?

You can use Tableau’s inbuilt pivot method ...READ MORE

answered Jul 9, 2018 in Tableau by Atul
• 5,530 points
891 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
4,306 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
286 views
+2 votes
1 answer
0 votes
1 answer

How to add a story with same sheet with different parameters and filters added in tableau?

Hi Riya, Follow these steps to add sheets/dashboard ...READ MORE

answered Mar 22, 2019 in Tableau by Cherukuri
• 32,460 points
413 views
0 votes
1 answer

How to create a waterfall chart in tableau?

Hi, Follow theses steps: 1. Select profit and order date ...READ MORE

answered Mar 26, 2019 in Tableau by Cherukuri
• 32,460 points
133 views