Note that there is quite a bit more to this than just selecting the data in column R and inserting a chart. At this point I will assume you can create the background banding from the stacked area chart following the tutorial.Ģ) When you come to the steps where he adds the real data to the chart, switch over to Peltier's tutorial for the waterfall chart ( the section using line chart with up-down bars) or xelplus's tutorial for the same technique ( ) and build the waterfall chart. His tutorial includes instructions for starting both ways, so choose the approach you want to use. In a broad overview, here's how I would build this waterfall chart:ġ) Peltier's tutorial on using a stacked area to create the background banding ( ) claims that it is slightly easier to start with the background first, so I would start by building the banded background. I also notice that, where you example picture only shows values above 0, your example data seems to include the need to go both above and below 0 - which is an important consideration in building the waterfall chart. The stacked area chart will work okay for the banding, but your column chart is not going to work for the waterfall chart. If you are already using a stacked column chart type, or determine that you cannot combine waterfall + stacked column, then it should be a simple matter of adding the three additional data series for the background bands, moving them to the secondary axis, then formatting those three data series as desired.Īt this point, it looks you are trying a regular column chart for the waterfall chart and a stacked area chart for the background bands. Can you add additional data series to the chart? Can you make a waterfall + stacked column chart? I expect that Excel will block you at one of those steps with a message like "cannot add data series to some chart types" or "some chart types cannot be combined with others." If it will allow you to make a waterfall+stacked column combination chart type, it should then be a matter of formatting the stacked column part of the combination chart to give the desired background effect. If you are using a waterfall chart type, how much will Excel allow you to do. It is up to you how much you want to help us help you.įrom there, we need to determine if you are using the built in waterfall chart type or if you are using a stacked column chart type. We cannot require you to do these, but editing your profile and uploading your sample file to the forum will increase the number of users here who can help you and improve the quality of the help you receive. I also know that many of us, while we are willing to download samples direct from the forum, we are not willing to download sample files from outside of the forum. I know the forum limits links, but it does not limit file uploads for new users. If you are now using Excel 2019, it would help us help you if you would edit your forum profile to reflect the change. In order to help with the specifics, we will need to be sure of your Excel version, understand some of what you have tried, and be able to see your sample file. If that is the case, you may need to create the waterfall chart in the old fashioned way - as a stacked column chart, which should allow you the flexibility to add a colored background like in your picture. My impression from other discussions here suggests that the built in waterfall chart type is very limited in the formatting options available - so that it may not be possible to have a colored background like your picture shows. If you have upgraded to a newer version of Excel and are using the built in waterfall chart type, I cannot help. Without seeing what you have tried, I would expect to add the three additional data series, move them to the secondary axis, then format them to be mostly transparent and have no gap between columns, and any other formats desired. Your picture shows a combination of two stacked column charts - the main waterfall chart, and then a stacked column in the background that fills the chart area with the three classifications. If you are having trouble uploading a sample file, be sure to click on the reply to thread or go advanced buttons (to bring up the main post editor), then find the "manage attachments" link beneath the post editing field that will bring up the working file uploader.Īssuming you are still working in Excel 2010 as your profile indicates, I would assume that your existing waterfall chart is really a stacked column chart. Many of us prefer that files be attached to the forum post rather than go to 3rd party sites to download.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |