Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Including data in data table but not charting as a series or point
I need to chart monthly totals including YTD. When I include YTD in the data
table, then the wizard also charts YTD totals as a series or point. How can I see the YTD totals in the data table but NOT include it in the charting of my other monthly totals from the data table? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Including data in data table but not charting as a series or point
Hi:
One option is to can make the data series for YTD invisible by choosing the same colours for the data as for the background. HTH, Henk "pepper76" wrote: I need to chart monthly totals including YTD. When I include YTD in the data table, then the wizard also charts YTD totals as a series or point. How can I see the YTD totals in the data table but NOT include it in the charting of my other monthly totals from the data table? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Including data in data table but not charting as a series or point
Or use "None" for line, marker, area, etc.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "HEK" wrote in message ... Hi: One option is to can make the data series for YTD invisible by choosing the same colours for the data as for the background. HTH, Henk "pepper76" wrote: I need to chart monthly totals including YTD. When I include YTD in the data table, then the wizard also charts YTD totals as a series or point. How can I see the YTD totals in the data table but NOT include it in the charting of my other monthly totals from the data table? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Including data in data table but not charting as a series or p
I should clarify.
My series includes both monthly and YTD totals. Is there something different I should do in order to print the YTD totals in the data table, but not have the YTD totals graphed in the table? "Jon Peltier" wrote: Or use "None" for line, marker, area, etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "HEK" wrote in message ... Hi: One option is to can make the data series for YTD invisible by choosing the same colours for the data as for the background. HTH, Henk "pepper76" wrote: I need to chart monthly totals including YTD. When I include YTD in the data table, then the wizard also charts YTD totals as a series or point. How can I see the YTD totals in the data table but NOT include it in the charting of my other monthly totals from the data table? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Including data in data table but not charting as a series or p
If you want the data in the data table, it must be charted. Henk and I
elaborated on ways to make the charted series invisible. Another option is to make your data table in the worksheet, either in the cells next to the chart, or make the table elsewhere and use the camera tool to put a dynamic copy of the table on or near the chart. Tushar Mehta describes some data table alternatives on his web site (http://tushar-mehta.com). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "pepper76" wrote in message ... I should clarify. My series includes both monthly and YTD totals. Is there something different I should do in order to print the YTD totals in the data table, but not have the YTD totals graphed in the table? "Jon Peltier" wrote: Or use "None" for line, marker, area, etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "HEK" wrote in message ... Hi: One option is to can make the data series for YTD invisible by choosing the same colours for the data as for the background. HTH, Henk "pepper76" wrote: I need to chart monthly totals including YTD. When I include YTD in the data table, then the wizard also charts YTD totals as a series or point. How can I see the YTD totals in the data table but NOT include it in the charting of my other monthly totals from the data table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Uniquely Identify Data for Charting with a List Box | Charts and Charting in Excel | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Charting Data Series vs. Data Points? | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) |