Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I am making a simple bar graph. every time I go to change the x axis from
numbers to year dates, the bars disappear??? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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??? |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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??? |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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??? |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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??? |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Can I make a graph to be a specific size? (actual graph) | Excel Discussion (Misc queries) | |||
Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel |