View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default max number of data ranges (bars) in a bar chart

Hi,

Is your data in non-contiguous ranges? If so this will create a reference
that maybe too long.

Either move the data to a contiguous range or create the chart on a small
set of data and then add each series separately.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"awaterworld" wrote in message
...
I am trying to create a simple bar graph with 23 different data ranges,
there
is all the room in the world for 23 bars in a single graph, yet when I
start
selecting the data ranges (or labels for that fact) it gets to about 17 of
them, and then erases everything I have selected and starts over. Ending
up
with a graph that only contains the last 4 or 5 data ranges????? I have
also
search every help and internet and see addressing this???