You can check out a post with a similar trick here: How-to Make a Wall Street Journal Horizontal Panel Chart in Excel
This is used to create a blank between the clusters.
You will also see a chart data series on the right called White Fill. There are 4 categories of the budget and expenditures related to Radio, Print, Television and Internet. Then I have a separate line for the budgeted advertising dollars and the actual advertising spent. So here is how we want to set up our data:Īs you can see, I have 2 products. This chart is going to compare the advertising spend on two different products in four categories for both budgeted numbers and actual numbers. You can check out other examples of charts that I have created with Multi-level Category Labels here: Case Study Solution – Mom Needing Help on Science Fair Graphs/Charts If you found the website and tutorials helpful, please consider donating to keep the lights on.
0 kommentar(er)
