I have a number of different worksheets that I input data to for different
periods. My number 1 sheet has my graph and data table that I print for my
report. All my sheets are set to automatically link to my number 1 sheet. My
problem is that in one of my worksheets I am using whole numbers eg:
1,234,567.00. Of course to have this whole number fit into the rest of my
graph I need to convert it to 3 decimal places eg: 1,234.567. In the data
table under my graph I have formatted the cell to accept 1,234.567 and this
is how you see it. Unfortunately the graph still sees it as 1,234,567.00
which has the column in the graph going way off the page. It seems the only
way around this is to break the link and manually type the number in. I am
hoping this makes sense and perhaps someone can show me the magic trick.