| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I get source data to show on a chart only if greater than z
I am creating a chart that depicts fleet expenses. I want the chart to draw
from the selected source data only if the value is greater than zero. I am knew to Excel and this has stumped me. I have 22 various entries for expenses (oil change, etc.). I want the chart to check the table and if there is an entry - chart it. Is this possible? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I get source data to show on a chart only if greater than z
In place of zero (or empty cell) use =NA(). This displays as #N/A and is
ignored by chart Alternatively, activate the chart; use Tools | Options and open the Chart option tab. There you can specify how empty cells are to be treated best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Mark" wrote in message ... I am creating a chart that depicts fleet expenses. I want the chart to draw from the selected source data only if the value is greater than zero. I am knew to Excel and this has stumped me. I have 22 various entries for expenses (oil change, etc.). I want the chart to check the table and if there is an entry - chart it. Is this possible? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I get source data to show on a chart only if greater than z
If cell is actually blank:
Go to Tools-Options-Chart Change it plot empty cells either as gaps, or interpolated. If cell has a 0 in it: Change the formula that generates the 0 so that is displays #N/A instead, i.e. =IF(A1B1,NA(),A1-B1) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mark" wrote: I am creating a chart that depicts fleet expenses. I want the chart to draw from the selected source data only if the value is greater than zero. I am knew to Excel and this has stumped me. I have 22 various entries for expenses (oil change, etc.). I want the chart to check the table and if there is an entry - chart it. Is this possible? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I get source data to show on a chart only if greater th
Thank You,
I tried it and it seems to be working great. I appreciate you taking the time to help me out. Thanks, Mark. "Bernard Liengme" wrote: In place of zero (or empty cell) use =NA(). This displays as #N/A and is ignored by chart Alternatively, activate the chart; use Tools | Options and open the Chart option tab. There you can specify how empty cells are to be treated best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Mark" wrote in message ... I am creating a chart that depicts fleet expenses. I want the chart to draw from the selected source data only if the value is greater than zero. I am knew to Excel and this has stumped me. I have 22 various entries for expenses (oil change, etc.). I want the chart to check the table and if there is an entry - chart it. Is this possible? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I get source data to show on a chart only if greater th
Thanks Luke,
It works! Thanks for your time. Mark. "Luke M" wrote: If cell is actually blank: Go to Tools-Options-Chart Change it plot empty cells either as gaps, or interpolated. If cell has a 0 in it: Change the formula that generates the 0 so that is displays #N/A instead, i.e. =IF(A1B1,NA(),A1-B1) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mark" wrote: I am creating a chart that depicts fleet expenses. I want the chart to draw from the selected source data only if the value is greater than zero. I am knew to Excel and this has stumped me. I have 22 various entries for expenses (oil change, etc.). I want the chart to check the table and if there is an entry - chart it. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart to show totals by monthly when source data is by day | Excel Discussion (Misc queries) | |||
| pie chart & column chart w/same source data | Charts and Charting in Excel | |||
| Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
