Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart - making positive values into negative ones?
I have an Excel chart where one of the sets of data (vertical bars) would be
better displayed on the underside of the x axis (i.e. negative instead of positive). Is there any way I can make this happen using the chart formatting features? If not presumably I shall create another column to calculate the negative data, and then plot that. TIA V |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart - making positive values into negative ones?
Victor Delta wrote:
I have an Excel chart where one of the sets of data (vertical bars) would be better displayed on the underside of the x axis (i.e. negative instead of positive). Is there any way I can make this happen using the chart formatting features? If not presumably I shall create another column to calculate the negative data, and then plot that. That is indeed your best bet. Additionally, a stacked column chart will avoid staggering the positive and negative values along the x-axis. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart - making positive values into negative ones?
"smartin" wrote in message ... Victor Delta wrote: I have an Excel chart where one of the sets of data (vertical bars) would be better displayed on the underside of the x axis (i.e. negative instead of positive). Is there any way I can make this happen using the chart formatting features? If not presumably I shall create another column to calculate the negative data, and then plot that. That is indeed your best bet. Additionally, a stacked column chart will avoid staggering the positive and negative values along the x-axis. You can avoid this offset by changing the overlap to 100%. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart - making positive values into negative ones?
"Jon Peltier" wrote in message
... "smartin" wrote in message ... Victor Delta wrote: I have an Excel chart where one of the sets of data (vertical bars) would be better displayed on the underside of the x axis (i.e. negative instead of positive). Is there any way I can make this happen using the chart formatting features? If not presumably I shall create another column to calculate the negative data, and then plot that. That is indeed your best bet. Additionally, a stacked column chart will avoid staggering the positive and negative values along the x-axis. You can avoid this offset by changing the overlap to 100%. Many thanks to both of you for your suggestions. V |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart - making positive values into negative ones?
"Jon Peltier" wrote in message
... "smartin" wrote in message ... Victor Delta wrote: I have an Excel chart where one of the sets of data (vertical bars) would be better displayed on the underside of the x axis (i.e. negative instead of positive). Is there any way I can make this happen using the chart formatting features? If not presumably I shall create another column to calculate the negative data, and then plot that. That is indeed your best bet. Additionally, a stacked column chart will avoid staggering the positive and negative values along the x-axis. You can avoid this offset by changing the overlap to 100%. I created the new column today with a formula that generates the negative value, and plotted that instead of the original positive vale. That was fine. However, then an Excel 'gotcha' got me. When I hid the column, the corresponding bars disappeared off the graph! Surely there is a way of plotting hidden date in a spreadsheet? I can't believe it's impossible. V |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart - making positive values into negative ones?
That's a default setting that suppresses plotting of hidden data. You can
change this on a chart by chart basis. In Excel 2003 and earlier: Tools menu Options Chart tab, uncheck Plot Visible Cells Only. In Excel 2007: Chart Tools - Design tab Select Data Hidden and Empty Cells button Check Show data in hidden rows and columns. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Victor Delta" wrote in message ... "Jon Peltier" wrote in message ... "smartin" wrote in message ... Victor Delta wrote: I have an Excel chart where one of the sets of data (vertical bars) would be better displayed on the underside of the x axis (i.e. negative instead of positive). Is there any way I can make this happen using the chart formatting features? If not presumably I shall create another column to calculate the negative data, and then plot that. That is indeed your best bet. Additionally, a stacked column chart will avoid staggering the positive and negative values along the x-axis. You can avoid this offset by changing the overlap to 100%. I created the new column today with a formula that generates the negative value, and plotted that instead of the original positive vale. That was fine. However, then an Excel 'gotcha' got me. When I hid the column, the corresponding bars disappeared off the graph! Surely there is a way of plotting hidden date in a spreadsheet? I can't believe it's impossible. V |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart - making positive values into negative ones?
"Jon Peltier" wrote in message
... That's a default setting that suppresses plotting of hidden data. You can change this on a chart by chart basis. In Excel 2003 and earlier: Tools menu Options Chart tab, uncheck Plot Visible Cells Only. In Excel 2007: Chart Tools - Design tab Select Data Hidden and Empty Cells button Check Show data in hidden rows and columns. Jon You are a star - many thanks. V |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Negative with Positive Values | Excel Discussion (Misc queries) | |||
making a # value positive or negative based on contents of another | Excel Worksheet Functions | |||
Excel chart with positive and negative values | Charts and Charting in Excel | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions |