Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Chart Display
I have set up many dynamic charts using named ranges with the counta
function. At times when reopened the data is not displayed properly - it will be skewed to the left with blank intervals although all data is there. It can be corrected by going to the data sheet and resaving the spreadsheet but this is very inconvenient and doesn't always work. This is particularly a problem when the spreadsheet is for distribution or to be used as part of a presentation. Does anyone know if there is a way to 'freeze' the display so this does not occur? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needing to re-order a datatable display on an Excel chart | Charts and Charting in Excel | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
How to display the negative bar in bar chart? | Charts and Charting in Excel | |||
Dynamic Time Display | Excel Worksheet Functions |