Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 14th 08, 03:09 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,355
Default Exclude some series from Data Table

I'd like to create multiple series so that I can change the color of
individual points based upon the value. I also would like to show a data
table of the values, however, when I add the additional series, those values
show in the data table. Does anyone have any suggestion on how to proceed?
Thanks,
Barb Reinhardt


  #2   Report Post  
Old March 14th 08, 04:16 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Exclude some series from Data Table

Don't use a data table. They're rather inflexible, so I generally make a
custom table in the range near the chart. I can include or exclude any data,
and arrange and format it how I want to.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Barb Reinhardt" wrote in message
...
I'd like to create multiple series so that I can change the color of
individual points based upon the value. I also would like to show a data
table of the values, however, when I add the additional series, those
values
show in the data table. Does anyone have any suggestion on how to
proceed?
Thanks,
Barb Reinhardt





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exclude zeros from series Arch Stanton Charts and Charting in Excel 2 October 13th 07 10:21 PM
In series of 10 digit #s, how can I exclude 1st 3 digits in each? readystate Excel Worksheet Functions 3 June 8th 07 02:59 AM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
EXCLUDE ADDRESSES IN A SERIES SUM viktaur Excel Worksheet Functions 1 March 9th 05 04:20 PM
Use the "mouse over" event to exclude a data point from a series Randall Hiltz Charts and Charting in Excel 10 January 19th 05 06:20 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017