Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic chart
Hi All,
I have a problem with charting some data that I hope you can help me with. What I have is data in two rows: Row 29 is the dates on a quaterly basis (Q2-05 and the sorts) with the lowest date in column 3 and quaterly on through the columns. Row 30 is the values to the corresponding dates in row 29 My problem is that the values derived in row 29 and 30 are derrived by formula. Hence when I make a chart of it i get alot of zero values in my chart.. Also the start of the data series I would like to chart might have zeroes until column 10 or 15 or something like that. Also, when the data starts for instances in column 7 it might have empty (not emptry but with an blank result of the formula) cells that I do not want to chart. If this is not enough info please tell me what would be useful. Best regards, Bondi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic chart
Bondi
There's a page on how to create dynamic charts he http://www.tushar-mehta.com/excel/ne...ynamic_charts/ That should get you started - ask again if you need to know more. Andrew On 5 Feb, 18:00, "Bondi" wrote: Hi All, I have a problem with charting some data that I hope you can help me with. What I have is data in two rows: Row 29 is the dates on a quaterly basis (Q2-05 and the sorts) with the lowest date in column 3 and quaterly on through the columns. Row 30 is the values to the corresponding dates in row 29 My problem is that the values derived in row 29 and 30 are derrived by formula. Hence when I make a chart of it i get alot of zero values in my chart.. Also the start of the data series I would like to chart might have zeroes until column 10 or 15 or something like that. Also, when the data starts for instances in column 7 it might have empty (not emptry but with an blank result of the formula) cells that I do not want to chart. If this is not enough info please tell me what would be useful. Best regards, Bondi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic chart
On 6 Feb., 00:24, "Andrew Taylor" wrote:
Bondi There's a page on how to create dynamic charts hehttp://www.tushar-mehta.com/excel/ne...ynamic_charts/ That should get you started - ask again if you need to know more. Andrew On 5 Feb, 18:00, "Bondi" wrote: Hi All, I have a problem with charting some data that I hope you can help me with. What I have is data in two rows: Row 29 is the dates on a quaterly basis (Q2-05 and the sorts) with the lowest date in column 3 and quaterly on through the columns. Row 30 is the values to the corresponding dates in row 29 My problem is that the values derived in row 29 and 30 are derrived by formula. Hence when I make a chart of it i get alot of zero values in my chart.. Also the start of the data series I would like to chart might have zeroes until column 10 or 15 or something like that. Also, when the data starts for instances in column 7 it might have empty (not emptry but with an blank result of the formula) cells that I do not want to chart. If this is not enough info please tell me what would be useful. Best regards, Bondi- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - Thanks all Sorted it out now Regards, Bondi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart- curve dropping to zero ( chart type- Line) | Charts and Charting in Excel | |||
Dynamic Chart Title With 3D Stacked Column Chart | Charts and Charting in Excel | |||
Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
Dynamic Chart Range and Chart Update | Excel Programming |