Unexpected Behavior from Worksheet to Unembeded Chart

gwright1

New Member
Joined
Dec 2, 2007
Messages
2
Preliminary "explanation" before the problem.
I keep track of my gas mileage via a spreadsheet and three corresponding clustered-column charts (Gallons, Trip Miles and MPG).
Nine column-values are the most eye-pleasing.
Problem: I just filled up last week and was going to add the new data.
Column Headings:
DATE, GALLONS, PRICE/GAL, FUEL SALE, ODOMETER, TRIP MILES, MPG
I have formulas to compute FUEL SALE, TRIP MILES, MPG
Rows:
Fill-up dates (total 9 per chart)
(If I'm on the first row of a new worksheet, I label the rows alphabetically B through I; and insert interim numbers to raise the chart columns above the X axis.)
PROBLEM DESCRIPTION
I'm ready to add last week's fillup. Before adding, each chart displays the dates properly (Date #1: 25-Jan through date #8: 25-Oct)
When I replace the interim "I" in cell A-10 with 11/29 (formated to 29-Nov), all three charts end up with two extra dates and are formatted in Mmm-Yy style (Jan-07 through Nov-07).
I'm thinking I must have a box checked which shouldn't be, or vice versa.

Thanks ever so much,
Stumped
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top