Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Gap Chart
How do you make a chart that shows a gap from the target? In my graph the
Target is a solid line. My Actual is bar but I have it not shown, and my Gap from Target is bar also. But I want to show an empty space between the Target and Gap from Target Example: Name Target Actual Gap from Target Alan 100 % 85% 15% Bill 90% 90% 0% Sue 80% 70% 10% |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Gap Chart
What does "My Actual is bar but I have it not shown" mean? That you are not
plotting the actual value? That you have formatted the bar to be invisible? Something else altogether? Also, what does "I want to show an empty space between the Target and Gap from Target" mean? Doesn't Actual + Gap-from-target = Target? So, if you have actual and gap-from-target as a stacked column chart, they will, by definition, touch the target! -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "Gap from Target" wrote: How do you make a chart that shows a gap from the target? In my graph the Target is a solid line. My Actual is bar but I have it not shown, and my Gap from Target is bar also. But I want to show an empty space between the Target and Gap from Target Example: Name Target Actual Gap from Target Alan 100 % 85% 15% Bill 90% 90% 0% Sue 80% 70% 10% |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Gap Chart
My Actual is graphed as a bar but it is invisible. The reason for an empty
space between Target and Gap from Target is to show how far off it from the Target. Does this make sense? "Tushar Mehta" wrote: What does "My Actual is bar but I have it not shown" mean? That you are not plotting the actual value? That you have formatted the bar to be invisible? Something else altogether? Also, what does "I want to show an empty space between the Target and Gap from Target" mean? Doesn't Actual + Gap-from-target = Target? So, if you have actual and gap-from-target as a stacked column chart, they will, by definition, touch the target! -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "Gap from Target" wrote: How do you make a chart that shows a gap from the target? In my graph the Target is a solid line. My Actual is bar but I have it not shown, and my Gap from Target is bar also. But I want to show an empty space between the Target and Gap from Target Example: Name Target Actual Gap from Target Alan 100 % 85% 15% Bill 90% 90% 0% Sue 80% 70% 10% |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Gap Chart
No, unfortunately, it's not clear what you want. As I mentioned in the
previous post 'Gap from target' when stacked on top of the actual will, by definition, touch the target. There can be no empty space. Maybe, what you want is to show the actual and make the 'gap from target' invisible. Of course, in that case, you could just skip plotting that series. -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "Gap from Target" wrote: My Actual is graphed as a bar but it is invisible. The reason for an empty space between Target and Gap from Target is to show how far off it from the Target. Does this make sense? "Tushar Mehta" wrote: What does "My Actual is bar but I have it not shown" mean? That you are not plotting the actual value? That you have formatted the bar to be invisible? Something else altogether? Also, what does "I want to show an empty space between the Target and Gap from Target" mean? Doesn't Actual + Gap-from-target = Target? So, if you have actual and gap-from-target as a stacked column chart, they will, by definition, touch the target! -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "Gap from Target" wrote: How do you make a chart that shows a gap from the target? In my graph the Target is a solid line. My Actual is bar but I have it not shown, and my Gap from Target is bar also. But I want to show an empty space between the Target and Gap from Target Example: Name Target Actual Gap from Target Alan 100 % 85% 15% Bill 90% 90% 0% Sue 80% 70% 10% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel |