=SERIES(,Trainings!$BG$5:$BG$11,Trainings!$BO$5:$B O$11,4)
The "4" inside the last paren indicates this formula is for the 4th
series. Select a series and use the arrow keys to cycle through the
other series (and other chart elements). See any gaps in the series
numbering? Do the selection indicators ever drop to the bottom for a series?
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
On 3/5/2010 2:41 PM, afdmello wrote:
Jon,
How can I determine there is a blank series?
I have 7 rows of data and 2 columns of data and that is plotted
=SERIES(,Trainings!$BG$5:$BG$11,Trainings!$BO$5:$B O$11,4)
afd
"Jon wrote in message
...
Sounds like you have a blank series, which without overlap pushes the
other series to the side so there is room for both.
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
On 3/5/2010 10:46 AM, afdmello wrote:
Thank you Jon and trip to Tokyo, I checked out again and observed that
the
labels are in the center between the tick marks
The labels are not week days but they are text. The truth is the bars are
not in the center of the tick marks.
I clicked in the chart area format data series Series overlap( was
2%) I
made it 100% ( the bar became bigger in width). Next I clicked on Gap
width( was105%) made it 200% and now it is OK
Just posted to ensure my workaround was accepted by the gurus
Thank you for your time and suggestions
afd
"Jon wrote in message
...
Is it a date-scale axis? For example, if you have weekly data, often you
get a tick for the beginning of the week, but the data is elsewhere in
the
week.
Are the labels oriented other than horizontal or vertical? Inclined
labels
seem to align with the planets, not with the chart.
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
On 3/5/2010 5:39 AM, afdmello wrote:
I have made a bar chart but the axis descriptors are not aligned with
the
bar. What I mean to say is they are not in the middle of the tick marks
How can i align them?
afd