| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination chart x-axes
Hi,
How can I make sure that the categories for a column chart are equally distributed along the whole length of the x axis to correspond to the scatter chart series. The x-value of the scatter chart and the categories of the column chart are dates, and I need them to be aligned. At the moment, I have column chart series that are squashed up against the primary y axis! Any help most welcome! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
combination chart x-axes
Put the columns onto a time scale axis. Select the chart, go to Chart menu
Chart Options Axes tab, and for category axis, choose the Date Scale option. The dates of the XY series should line up on this axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Rab" wrote in message ... Hi, How can I make sure that the categories for a column chart are equally distributed along the whole length of the x axis to correspond to the scatter chart series. The x-value of the scatter chart and the categories of the column chart are dates, and I need them to be aligned. At the moment, I have column chart series that are squashed up against the primary y axis! Any help most welcome! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
combination chart x-axes
Many thanks, Jon.
"Jon Peltier" wrote: Put the columns onto a time scale axis. Select the chart, go to Chart menu Chart Options Axes tab, and for category axis, choose the Date Scale option. The dates of the XY series should line up on this axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Rab" wrote in message ... Hi, How can I make sure that the categories for a column chart are equally distributed along the whole length of the x axis to correspond to the scatter chart series. The x-value of the scatter chart and the categories of the column chart are dates, and I need them to be aligned. At the moment, I have column chart series that are squashed up against the primary y axis! Any help most welcome! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combination of stock chart and line chart | Charts and Charting in Excel | |||
| Combination chart - Line - Column on 2 Axes | Charts and Charting in Excel | |||
| Having two X-axes on same chart | Excel Discussion (Misc queries) | |||
| XY-Chart with 4 axes | Charts and Charting in Excel | |||
| How to lock combination chart in pivot chart? | Charts and Charting in Excel | |||
Linear Mode
