Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - date with errors #DIV/0!
Abr Mai Jun
Enc. Auto 58% 54% #DIV/0! Enc. Semi 30% 31% #DIV/0! Manuais 12% 15% #DIV/0! I have this table and i want to do a chart type Area. I don't have data in Jun and i don't want that the line goes down to zero. I dont want that any values appear. Regards, SBárbara |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - date with errors #DIV/0!
Change the formula that computes the average to something on the lines of"
=IF(B10, A1/B1, NA()) This will replace the dreaded div/0 BY #NO/A which Excel ignores when charting best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "SBárbara" wrote in message ... Abr Mai Jun Enc. Auto 58% 54% #DIV/0! Enc. Semi 30% 31% #DIV/0! Manuais 12% 15% #DIV/0! I have this table and i want to do a chart type Area. I don't have data in Jun and i don't want that the line goes down to zero. I dont want that any values appear. Regards, SBárbara |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - date with errors #DIV/0!
Hi,
I already tried that, but I think that the type of chart I want to use doesn't allow -- type area subtype Stacked area. Can you help me? Thanks "Bernard Liengme" escreveu: Change the formula that computes the average to something on the lines of" =IF(B10, A1/B1, NA()) This will replace the dreaded div/0 BY #NO/A which Excel ignores when charting best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "SBárbara" wrote in message ... Abr Mai Jun Enc. Auto 58% 54% #DIV/0! Enc. Semi 30% 31% #DIV/0! Manuais 12% 15% #DIV/0! I have this table and i want to do a chart type Area. I don't have data in Jun and i don't want that the line goes down to zero. I dont want that any values appear. Regards, SBárbara |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAX value of a column that has #div/0 errors in it | Excel Discussion (Misc queries) | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
How do I chart date ranges with varying start and finish dates? | Charts and Charting in Excel | |||
how to show date on the x axis of a line chart? | Charts and Charting in Excel |