| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
Column chart - category axis - make to start with the second label
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. |
|
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
|
Column chart - category axis - make to start with the second label
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" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
|
Column chart - category axis - make to start with the secondlabel
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" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
|
Column chart - category axis - make to start with the secondlabel
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a chart with column A on xaxis & column B on Yaxis | Excel Discussion (Misc queries) | |||
| How do I print comments on a chart? | Charts and Charting in Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Dynamic Bar Chart Category Axis Problem | Charts and Charting in Excel | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
Linear Mode
