mikeygriff

Is it possible to format a negative value to display as a positive value, even thought the chart is driven by the negative value! Hope that makes sense!? It would enable me to create an Age Distribution type chart where values for males and females are displayed in a stacked bat around a central axis, with male values extending to the left, female to the right (see attachment). Or could this be achieved using a different chart type?