Prev: How to do a pivot table with 2 different results
Next: Secondary Axis - Alignment of Dollar Values
From: afdmello on 5 Mar 2010 14:41
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:$BO$11,4)

afd
"Jon Peltier" <jonNO(a)SPAMpeltiertech.com> wrote in message
news:eq9zLoJvKHA.3860(a)TK2MSFTNGP06.phx.gbl...
> 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 Peltier"<jonNO(a)SPAMpeltiertech.com> wrote in message
>> news:%23FtLlQGvKHA.796(a)TK2MSFTNGP05.phx.gbl...
>>> 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
>>>>
>>>>
>>
>>


From: Jon Peltier on 6 Mar 2010 22:59
> =SERIES(,Trainings!$BG$5:$BG$11,Trainings!$BO$5:$BO$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:$BO$11,4)
>
> afd
> "Jon Peltier"<jonNO(a)SPAMpeltiertech.com> wrote in message
> news:eq9zLoJvKHA.3860(a)TK2MSFTNGP06.phx.gbl...
>> 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 Peltier"<jonNO(a)SPAMpeltiertech.com> wrote in message
>>> news:%23FtLlQGvKHA.796(a)TK2MSFTNGP05.phx.gbl...
>>>> 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
>>>>>
>>>>>
>>>
>>>
>
>
First  |  Prev  | 
Pages: 1 2
Prev: How to do a pivot table with 2 different results
Next: Secondary Axis - Alignment of Dollar Values