Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#6
![]() |
|||
|
|||
![]()
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.
__________________
I am not human. I am an Excel Wizard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
negative [h]:mm:ss does not show on the x axis of a chart | Charts and Charting in Excel | |||
Not all column titles show on x axis on chart | Charts and Charting in Excel | |||
negative [h]:mm:ss does not show on the x axis of a chart | Charts and Charting in Excel | |||
Show quarters and years on x axis of a chart | Charts and Charting in Excel | |||
only show workdays in a cell | Excel Worksheet Functions |