Dear experts!
Is it possible to make column chart type - category axis to start with the
second label instead of the first?
Thanks for the answers,
Marko.
Dear experts!
Is it possible to make column chart type - category axis to start with the
second label instead of the first?
Thanks for the answers,
Marko.
Don't include the first label and Y value in the source data range.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"Marko Pinteric" <[email protected]> wrote in message
news:[email protected]...
> Dear experts!
>
> Is it possible to make column chart type - category axis to start with the
> second label instead of the first?
>
> Thanks for the answers,
>
> Marko.
>
>
I want first Y value, but I want labels to start witn the second label
e.g. I have:
9:30 val1
10:00 val2
10:30 val3
etc.
Labels on x axis are 9:30, 10:30, 11:30 etc., but I want labels in
x axis to be 10:00, 11:00, 12:00 etc.
Best regards,
Marko.
Jon Peltier wrote:
> Don't include the first label and Y value in the source data range.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> "Marko Pinteric" <[email protected]> wrote in message
> news:[email protected]...
>
>>Dear experts!
>>
>>Is it possible to make column chart type - category axis to start with the
>>second label instead of the first?
>>
>>Thanks for the answers,
>>
>>Marko.
>>
>>
>
>
>
Hi,
If the cell data is really a time value then set the Number format of
the x axis to be [White][<0.4]hh:mm;hh:mm
Assuming White is the chart area colour. Also set the font background to
be Transparent.
Cheers
Andy
Marko Pinteric wrote:
>
> I want first Y value, but I want labels to start witn the second label
>
> e.g. I have:
>
> 9:30 val1
> 10:00 val2
> 10:30 val3
> etc.
>
> Labels on x axis are 9:30, 10:30, 11:30 etc., but I want labels in
> x axis to be 10:00, 11:00, 12:00 etc.
>
> Best regards,
>
> Marko.
>
> Jon Peltier wrote:
>
>> Don't include the first label and Y value in the source data range.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Peltier Technical Services
>> Tutorials and Custom Solutions
>> http://PeltierTech.com/
>> _______
>>
>> "Marko Pinteric" <[email protected]> wrote in message
>> news:[email protected]...
>>
>>> Dear experts!
>>>
>>> Is it possible to make column chart type - category axis to start
>>> with the second label instead of the first?
>>>
>>> Thanks for the answers,
>>>
>>> Marko.
>>>
>>>
>>
>>
>>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks