If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Stacked chart - Need overlapping!!!
I have created a chart that has multiple data.
Goal - 2000000 Present - 4,500,000 January - 450,000 I have the column stacked on top of each other. BUT THE PROBLEM IS that if someone is reading the graph they think that presently we are at 6,500,000. Because the goal is below it @ 2,000,000 and it adds the presently on top of it. I need them to over lap each other. So the numbers on the left are correct. I have used a stacked column graph. |
#2
|
|||
|
|||
Stacked chart - Need overlapping!!!
Hi,
Don't stack the columns then. Use Cluster column chart type instead. Set the overlap value to 100. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Mayur" wrote in message ... I have created a chart that has multiple data. Goal - 2000000 Present - 4,500,000 January - 450,000 I have the column stacked on top of each other. BUT THE PROBLEM IS that if someone is reading the graph they think that presently we are at 6,500,000. Because the goal is below it @ 2,000,000 and it adds the presently on top of it. I need them to over lap each other. So the numbers on the left are correct. I have used a stacked column graph. |
Thread Tools | |
Display Modes | |
|
|