Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a spreadsheet with a bar chart already in it (it's showing the number
of quotes sent monthly w/ trendlines). In column A, I have a month-year and in column B, I have the number of quotes sent in that month. I changed the source data to display a different set of months, and the bar widths narrowed down to the width of a line. I undid the change and the bar widths went back. I then tried to edit the chart formula one cell at a time and found that when I reached a particular month forward in time, that that's when the change occurred (row 40). I thought maybe it was because I was adding too many months to fit in the chart, so I started removing months on the front end of it to keep the total number of bars static but that didn't make an impact. Then I noticed that as soon as I add that one month to the source data, the bottom axis (is that X or Y, I forget) switches from monthly to weekly which is why all the bars change width. So my question is, what is it about that cell is causing my chart to switch like that? I only have monthly numbers in column A, no weekly numbers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA to automatically change source data for existing chart | Charts and Charting in Excel | |||
VBA to automatically change source data for existing chart | Charts and Charting in Excel | |||
Line disappearing from chart after changing data source | Charts and Charting in Excel | |||
Add source data to an existing chart? | Charts and Charting in Excel | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel |