Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column Chart, Displaying two values on one column.
Hello,
Is it possible to display two value on one column. For example Budget = 4.6% Actual = -6.0% I can display this on a column without any problems, one column for budget and one for actual. Is it possible to add another value to the Actual so it displays on the same column but in a different colour? For example I would like to add: Net = 2.3% and display this on the Actual column in a different colour. Any help would be appreciated. Thanks, Brett |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column Chart, Displaying two values on one column.
You can format a stacked column chart to resemble a clustered-stacked column
chart: http://peltiertech.com/Excel/ChartsH...sterStack.html Keep in mind that stacking positive and negative items in a column chart very often does not give the desired result. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ups.com... Hello, Is it possible to display two value on one column. For example Budget = 4.6% Actual = -6.0% I can display this on a column without any problems, one column for budget and one for actual. Is it possible to add another value to the Actual so it displays on the same column but in a different colour? For example I would like to add: Net = 2.3% and display this on the Actual column in a different colour. Any help would be appreciated. Thanks, Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stacked column chart with negative values | Charts and Charting in Excel | |||
comparing 2 values on one column in chart | Charts and Charting in Excel | |||
Column chart not displaying some data points - Excel 2003 | Charts and Charting in Excel | |||
problems with displaying "duplicate vlookup values" in same column | Excel Discussion (Misc queries) | |||
Column Chart with 2 values in each column | Charts and Charting in Excel |