Show only workdays in chart axis?
Hi,
I have created a dynamic named-range that I use as the data source for my scatter plot chart's x-axis. I only type in dates that are workdays in that range. When I graph my data the chart is still showing the weekends, just with no data points in there. It is stretching my graph out and skewing the look. Is there a way to set the graph to only show weekdays and just skip the weekends? Thanks! -Dan |
Answer: Show only workdays in chart axis?
Hi Dan,
Yes, there is a way to set the graph to only show weekdays and skip weekends. Here are the steps:
Your chart should now only show weekdays and skip weekends on the x-axis. |
Show only workdays in chart axis?
I should add I have tried right-clicking on the chart - chart options -
axes - and trying to select the Category radio button but it is grayed out, possibly because I am using a named field as the data source? "Dan" wrote: Hi, I have created a dynamic named-range that I use as the data source for my scatter plot chart's x-axis. I only type in dates that are workdays in that range. When I graph my data the chart is still showing the weekends, just with no data points in there. It is stretching my graph out and skewing the look. Is there a way to set the graph to only show weekdays and just skip the weekends? Thanks! -Dan |
Show only workdays in chart axis?
Goto Chart OptionsAxes and change Category (X) Axis to Category
-- __________________________________ HTH Bob "Dan" wrote in message ... I should add I have tried right-clicking on the chart - chart options - axes - and trying to select the Category radio button but it is grayed out, possibly because I am using a named field as the data source? "Dan" wrote: Hi, I have created a dynamic named-range that I use as the data source for my scatter plot chart's x-axis. I only type in dates that are workdays in that range. When I graph my data the chart is still showing the weekends, just with no data points in there. It is stretching my graph out and skewing the look. Is there a way to set the graph to only show weekdays and just skip the weekends? Thanks! -Dan |
Show only workdays in chart axis?
Hi,
You need to change the chart type to Line rather than xy-scatter in order to swap between Category and Time series axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Dan" wrote in message ... I should add I have tried right-clicking on the chart - chart options - axes - and trying to select the Category radio button but it is grayed out, possibly because I am using a named field as the data source? "Dan" wrote: Hi, I have created a dynamic named-range that I use as the data source for my scatter plot chart's x-axis. I only type in dates that are workdays in that range. When I graph my data the chart is still showing the weekends, just with no data points in there. It is stretching my graph out and skewing the look. Is there a way to set the graph to only show weekdays and just skip the weekends? Thanks! -Dan |
Show only workdays in chart axis?
Thanks Andy! That did it!
-Dan "Andy Pope" wrote: Hi, You need to change the chart type to Line rather than xy-scatter in order to swap between Category and Time series axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Dan" wrote in message ... I should add I have tried right-clicking on the chart - chart options - axes - and trying to select the Category radio button but it is grayed out, possibly because I am using a named field as the data source? "Dan" wrote: Hi, I have created a dynamic named-range that I use as the data source for my scatter plot chart's x-axis. I only type in dates that are workdays in that range. When I graph my data the chart is still showing the weekends, just with no data points in there. It is stretching my graph out and skewing the look. Is there a way to set the graph to only show weekdays and just skip the weekends? Thanks! -Dan |
All times are GMT +1. The time now is 07:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com