#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default 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???
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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???


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default 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???



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default 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???



  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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???






  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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???




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I graph data daily as a line graph across a calendar format Glani Charts and Charting in Excel 3 November 23rd 07 09:05 AM
Cluster stacked graph AND line combo graph? [email protected] Charts and Charting in Excel 6 October 14th 06 12:33 AM
Can I make a graph to be a specific size? (actual graph) Jessica Excel Discussion (Misc queries) 0 August 14th 06 08:45 PM
Creating a graph similar to a stacked column graph Jonathan Charts and Charting in Excel 6 August 4th 06 04:23 PM
Hyperlinkage of one graph with another graph or Drill down graph Sanjay Kumar Singh Charts and Charting in Excel 1 January 3rd 06 12:22 PM


All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"