0:00this graph
0:00in excel makes your reports look pro in seconds
0:03in this case
0:04I have a table of
0:05the sale
0:05of products where you can see the complete video
0:09you may not find it later
0:11select
0:12one of the arrows in this table and I am on my way to insert
0:16then I turn to graph
0:19existing framework
0:21for
0:21insert the attached graphic in a sheet that I have already created
0:25select for example here
0:27press enter
0:29press accept and automatically
0:31I have the dynamic table and the graph too
0:35on the right side the fields are enabled
0:38I will add for example product in axes and in values
0:42I add amount and add income
0:45and automatically
0:46the dynamic table and the three-dimensional graph are being built
0:50I am going to
0:51the names and in row label I will consider products
0:55I will adjust the width of the columns
0:58and this is the graph
1:01I keep this chart selected
1:03right click press
1:05press change graphic type
1:07and I get this floating picture
1:10I turn to combined graphic at the bottom
1:13this first graph
1:14and here is a sample of the graph
1:17and in
1:17the bottom part shows the two value variables
1:21amount e
1:22and on this right side I see the secondary axis
1:25in this case I will decline in income
1:28and as you can see
1:29appears in this way and this was added to the secondary axis
1:33then change the chart types
1:35in this case I am going to leave it as is
1:38in the case of income I will correct this graph
1:41then press accept
1:44I keep the chart selected
1:46and I turn to graph analysis.
1:49and deactivate the buttons
1:51now the buttons are no longer shown in the graph
1:54this legend
1:55I am going to change it and put it at the bottom.
1:59I adjust the size of the graph
2:02then I add the axis title and the graph titles
2:06graphic title
2:07I will consider sales by product
2:11of the bottom shaft
2:12left side shaft products
2:15amounts the shaft on the right side income
2:19I continue to adjust the size of the graph
2:22and there is the left graphic
2:24I will also add the data labels
2:27and I will change the width of the bars
2:30I select these bars on the right side here I write
2:34fifty
2:36and select the labels on the bars
2:39in label format
2:41frame this symbol and in position
2:43center frame
2:45saw that the position of the labels has now changed
2:48I am going to put it in bold
2:50and white color
2:52I can also change the color of these bars
2:55I'm going to paint a darker color
2:57I will also change the line labels
3:00or income
3:02I select these labels
3:04and I turn to tag format
3:06select this symbol in the position above
3:10and I'm going to change it color
3:12and also in bold
3:13to prevent the labels and values from being displayed
3:16in this way
3:17I select these values
3:19and I will change the format
3:22then I go on to analyze the whole dynamic
3:25then to insert time scale
3:28date frame accept
3:31and this time scale is added
3:34here for example
3:35I can select one month on time
3:37or I can see an accumulated
3:40it's that simple and fast you'll be able to
3:42build a three-dimensional graphic