software

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
PeltierTech.com/
_______

quot;Marko Pintericquot; gt; wrote in message
...
gt; Dear experts!
gt;
gt; Is it possible to make column chart type - category axis to start with the
gt; second label instead of the first?
gt;
gt; Thanks for the answers,
gt;
gt; Marko.
gt;
gt;

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:
gt; Don't include the first label and Y value in the source data range.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Marko Pintericquot; gt; wrote in message
gt; ...
gt;
gt;gt;Dear experts!
gt;gt;
gt;gt;Is it possible to make column chart type - category axis to start with the
gt;gt;second label instead of the first?
gt;gt;
gt;gt;Thanks for the answers,
gt;gt;
gt;gt;Marko.
gt;gt;
gt;gt;
gt;
gt;
gt;

Hi,

If the cell data is really a time value then set the Number format of
the x axis to be [White][lt;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:
gt;
gt; I want first Y value, but I want labels to start witn the second label
gt;
gt; e.g. I have:
gt;
gt; 9:30 val1
gt; 10:00 val2
gt; 10:30 val3
gt; etc.
gt;
gt; Labels on x axis are 9:30, 10:30, 11:30 etc., but I want labels in
gt; x axis to be 10:00, 11:00, 12:00 etc.
gt;
gt; Best regards,
gt;
gt; Marko.
gt;
gt; Jon Peltier wrote:
gt;
gt;gt; Don't include the first label and Y value in the source data range.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;Marko Pintericquot; gt; wrote in message
gt;gt; ...
gt;gt;
gt;gt;gt; Dear experts!
gt;gt;gt;
gt;gt;gt; Is it possible to make column chart type - category axis to start
gt;gt;gt; with the second label instead of the first?
gt;gt;gt;
gt;gt;gt; Thanks for the answers,
gt;gt;gt;
gt;gt;gt; Marko.
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info