Home |
Search |
Today's Posts |
#1
|
|||
|
|||
stock chart -- how to include only trading days
Trying to do a simple high-low-close stock chart. I have these three items
listed for each trading day in columns on the worksheet. Also have corresponding trading dates in a column. The chart insists on showing on the X axis all dates, including non-trading dates. On the body of the chart there are blanks between data points, corresponding to the non-trading dates. How can I get the X axis to omit the non-trading dates? Thanks in advance. Jordan Burkart |
#2
|
|||
|
|||
Excel saw the dates and assumed you wanted a time scale axis.
Choose Chart Options from the Chart menu, click on the Axes tab, and check Category for Category (X) Axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jordan Burkart wrote: Trying to do a simple high-low-close stock chart. I have these three items listed for each trading day in columns on the worksheet. Also have corresponding trading dates in a column. The chart insists on showing on the X axis all dates, including non-trading dates. On the body of the chart there are blanks between data points, corresponding to the non-trading dates. How can I get the X axis to omit the non-trading dates? Thanks in advance. Jordan Burkart |
#3
|
|||
|
|||
Jon,
Many thanks. Your suggestion did the trick. Never would have figured it out on my own. Jordan "Jon Peltier" wrote in message ... Excel saw the dates and assumed you wanted a time scale axis. Choose Chart Options from the Chart menu, click on the Axes tab, and check Category for Category (X) Axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jordan Burkart wrote: Trying to do a simple high-low-close stock chart. I have these three items listed for each trading day in columns on the worksheet. Also have corresponding trading dates in a column. The chart insists on showing on the X axis all dates, including non-trading dates. On the body of the chart there are blanks between data points, corresponding to the non-trading dates. How can I get the X axis to omit the non-trading dates? Thanks in advance. Jordan Burkart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Technical Indicator below Stock Chart | Charts and Charting in Excel | |||
Combination of stock chart and line chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
How do I not include empty cell value chart labels in pie charts? | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel |