bar graph
I am making a simple bar graph. every time I go to change the x axis from
numbers to year dates, the bars disappear??? |
bar graph
Hi,
What values are you setting the axis to? What are the min/max values of your data? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "adag59" wrote in message ... I am making a simple bar graph. every time I go to change the x axis from numbers to year dates, the bars disappear??? |
bar graph
min 1996 max 2007 values 1/years
"Andy Pope" wrote: Hi, What values are you setting the axis to? What are the min/max values of your data? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "adag59" wrote in message ... I am making a simple bar graph. every time I go to change the x axis from numbers to year dates, the bars disappear??? |
bar graph
when I try to put in the data range again to the chart already opened, it say
the data range is to complexed to display. we are only talking about 12 cells/12 bars "Andy Pope" wrote: Hi, What values are you setting the axis to? What are the min/max values of your data? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "adag59" wrote in message ... I am making a simple bar graph. every time I go to change the x axis from numbers to year dates, the bars disappear??? |
bar graph
If you set the axis to 1996 to 2007 then the actual values are
Min = 35065 Max = 39083 If your chart data is not within that range it will not appear. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "adag59" wrote in message ... min 1996 max 2007 values 1/years "Andy Pope" wrote: Hi, What values are you setting the axis to? What are the min/max values of your data? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "adag59" wrote in message ... I am making a simple bar graph. every time I go to change the x axis from numbers to year dates, the bars disappear??? |
bar graph
check you thread in the other newsgroup.
Please don't cross post. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "adag59" wrote in message ... when I try to put in the data range again to the chart already opened, it say the data range is to complexed to display. we are only talking about 12 cells/12 bars "Andy Pope" wrote: Hi, What values are you setting the axis to? What are the min/max values of your data? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "adag59" wrote in message ... I am making a simple bar graph. every time I go to change the x axis from numbers to year dates, the bars disappear??? |
All times are GMT +1. The time now is 08:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com