Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I try to create a floating column chart for the daily minimum and maximum
temperature. I start by create a stacked column chart by ploting two series of data: minimum temperature and (maximum - minimum) temperature, and then I make the minimum temperature series invisible. This work fine if the minimum and maxmum temperature both are above 0 degree or below 0 degree. It will not work if the minimum is less than 0 degree and maximum is greater than 0 degree. How can I solve this problem? Thanks. |
#2
![]() |
|||
|
|||
![]()
You could plot it in terms of absolute temperature and then use Rob Bovey's
chart labeler to identify the temp in the units you want. http://www.appspro.com/Utilities/ChartLabeler.htm "Gian" wrote in message ... I try to create a floating column chart for the daily minimum and maximum temperature. I start by create a stacked column chart by ploting two series of data: minimum temperature and (maximum - minimum) temperature, and then I make the minimum temperature series invisible. This work fine if the minimum and maxmum temperature both are above 0 degree or below 0 degree. It will not work if the minimum is less than 0 degree and maximum is greater than 0 degree. How can I solve this problem? Thanks. |
#3
![]() |
|||
|
|||
![]()
Gian -
This page tells how to deal with stacked column charts that cross the X axis: http://peltiertech.com/Excel/Charts/...eAndBelow.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Gian wrote: I try to create a floating column chart for the daily minimum and maximum temperature. I start by create a stacked column chart by ploting two series of data: minimum temperature and (maximum - minimum) temperature, and then I make the minimum temperature series invisible. This work fine if the minimum and maxmum temperature both are above 0 degree or below 0 degree. It will not work if the minimum is less than 0 degree and maximum is greater than 0 degree. How can I solve this problem? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clustered column chart with stacked coumns | Charts and Charting in Excel | |||
On a combination chart how do i get 2 lines and 1 column? | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Making Special "Stacked Column" Chart | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |