I am currently working on a revenue analysis and I would like to be able to create a clustered column chart that is also stacked. I would like to compare over twelve months Actual 2001 with Budget and Actual 2000 (ie. the clustered bit), and within these categories I would like to show how much of the total revenue is made up of new business and how much of renewal commission - (ie. the stacked bit). I cannot see how one could do it.
Another thing that really annoys me about Excel 97 that I would appreciate knowing about is whether you can pick which form you would like a data strand to take. This is with reference to Columns/Lines on 2 Axis custom charts - how can you effectively say all data logged on Y1 Axis should be a bar and all data logged on Y2 Axis a line?
Thanks!
Another thing that really annoys me about Excel 97 that I would appreciate knowing about is whether you can pick which form you would like a data strand to take. This is with reference to Columns/Lines on 2 Axis custom charts - how can you effectively say all data logged on Y1 Axis should be a bar and all data logged on Y2 Axis a line?
Thanks!