-
1. Re: Combining two tables into one bar graph?
swaroop.gantela Jun 29, 2016 5:18 PM (in response to Ryan Jablon)Ryan,
I'm not sure if this quite gets you there,
but you could maybe try putting Measure Values on your Row/Column shelf,
and then pulling in each of the amounts from your two sheets.
You could Group them just by the Quarter (not including the year) to get them side-by-side.
-
210150bar.twbx 26.2 KB
-
-
2. Re: Combining two tables into one bar graph?
Ryan Jablon Jun 30, 2016 10:59 AM (in response to swaroop.gantela)Hi Swaroop,
Thank you for your response. My one major difference is I'm dealing with a baseline of an entire year being 2015. It is not broken down into quarters and I'm trying to plot that along side 2016 Q1 and Q2.
-
3. Re: Combining two tables into one bar graph?
Ryan Jablon Jun 30, 2016 10:59 AM (in response to swaroop.gantela)Thank you for your response. My one major difference is I'm dealing with a baseline of an entire year being 2015. It is not broken down into quarters and I'm trying to plot that along side 2016 Q1 and Q2.
-
4. Re: Combining two tables into one bar graph?
swaroop.gantela Jun 30, 2016 11:40 AM (in response to Ryan Jablon)Ryan,
This doesn't look great, but you can maybe try some things with WINDOW_SUM
to aggregate the 2015 data.
Also, these links may have some useful ideas for you:
kettan's excellent posts on YOY YTD bars
-
210150barB.twbx 26.3 KB
-
-
5. Re: Combining two tables into one bar graph?
swaroop.gantela Jul 1, 2016 7:40 PM (in response to swaroop.gantela)Ryan,
Here is another stab at it.You can fix the 2015 amount using on the 2015 sheet:
{ FIXED [YearOfDate]:SUM([Value])}
Then on the 2016 sheet, you can calculate individual quarter amounts:
IF YEAR([Date])=2016 AND DATEPART('quarter',[Date])=3
THEN [Value]
END
And then you can put all of these on the Measure Values Shelf.
-
210150barC.twbx 31.4 KB
-
-
6. Re: Combining two tables into one bar graph?
remyakrishnan.v Sep 20, 2016 6:55 AM (in response to swaroop.gantela)1 of 1 people found this helpfulThese are the following procedure will help you create a combination chart , For this chart, we used the example worksheet data.
Create a blank workbook or worksheet.
- Select the example in the Help topic.
NOTE: Do not select the row or column headers.
Selecting an example from Help
- Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
a. Select the data that you want to plot in the combination chart.
b. On the Insert tab, in the Charts group, click Column.
c. Under 2-D Column, click Clustered Column.
d. In the chart, click the data series that you want to display in a different chart type, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
For our combination chart, we selected the data series for Average Price.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.
e. On the Design tab, in the Type group, click Change Chart Type.
NOTE: If the whole chart changes to a line chart, you need to make sure that only one data series is selected before you change the chart type.
f. Under Line, click Line with Markers, and then click OK.
g. To plot the line on a secondary axis, do the following:
- i. In the chart, click the line that represents Average Price once to select the data series, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
- ii. On the Layout tab, in the Current Selection group, click Format Selection.
iii. In the Series Options category, under Plot Series On, click Secondary Axis, and then click Close.
h. Click the chart area of the chart.
i. On the Design tab, in the Chart Styles group, click the chart style that you want to use.
For our combination chart, we used Style 42.
j. To change the size of the chart, on the Format tab, in the Size group, select the shape size that you want in the Shape Height and Shape Width boxes, and then press ENTER.
k. For our combination chart, we used 5 for the shape height and 5 for the shape width.
TIP: You can also resize a chart by dragging one of the corners of the chart until the chart reaches the size that you want.
l. To add, format, and position a chart title on the chart, click the chart area, and then do the following:
- i. On the Layout tab, in the Labels group, click Chart Title, and then click Above Chart.
ii. In the chart, click the chart title, and then type the text that you want.
For our combination chart, we typed Recent Home Sales.
- iii. To reduce the size of the chart title, right-click the title, and then enter the size that you want in the Size box on the shortcut menu.
For our combination chart, we used 18.
- m. To move the legend, do the following:
- i. Click the legend to select it.
- ii. On the Layout tab, in the Labels group, click Legend, and then click the position that you want.
For our combination chart, we clicked Show Legend at Bottom.
- n. To add vertical axis titles, do the following:
- i. On the Layout tab, in the Labels group, click Axis Titles, and then do the following:
- Click Primary Vertical Axis Title, and then click the title option that you want.
- Click Secondary Vertical Axis Title, and then click the title option that you want.
- i. On the Layout tab, in the Labels group, click Axis Titles, and then do the following:
For our combination chart, we clicked Rotated Title for both axes.
- ii. Click each axis title, and then type the text that you want for that title.
For our combination chart, we typed Number of homes for the primary vertical axis title and Average price per home in thousands for the secondary axis title.
- iii. To change the font size of the axis titles, click each axis title, and then click the size that you want in the Font Size box.
- iv.
- o. To change the appearance of the markers that are displayed on the Average Price line, do the following:
- i. Right-click a marker, and then click Format Data Series on the shortcut menu.
- ii. Click Marker Options, and then under Marker Type, click Built-in.
- iii. In the Type box, click the marker type that you want to use.
For our combination chart, we used a round marker type.
- p. Click the chart area of the chart.
- q. On the Format tab, in the Shape Styles group, click the More button , and then click the effect that you want to use.
For our combination chart, we used the Subtle Effect - Dark 1 for the chart area.
- r. If you want to use theme colors that are different from the default theme that is applied to your workbook, do the following:
- i. On the Page Layout tab, in the Themes group, click Themes.
- ii. Under Built-in, click the theme that you want to use.
For our combination chart, we used the Office theme.
Save a chart as a template
If you want to create another chart like the one that you just created, you can save the chart as a template that you can use as the basis for other similar charts.
- 1. Click the chart that you want to save as a template.
- 2. On the Design tab, in the Type group, click Save as Template.
- 1. In the File name box, type a name for the template.
For understanding more you can go in refer this <cloaked advertising removed>.