How to add asterisk to source data


    Sponsored Links


  • 2. Is there a posibbility to change/modify the Legends
    Could we customise the Chart legends without changing the Data Series ?
  • 3. How can I "break" the bar in a graph if a series is off the chart
    In a bar graph where all of the data series are of comparable magnitude except for one which is off the scale, it is useful to show a "break" in the off-the-chart bar so that you can adjust the Y axis scale to fit the other series more appropriately. I'm trying to find out whether it's possible to show this "break" in Excel. Grateful for any insights.
  • 4. Graph look up
    I have created a graph in excel with some standard values plotting A against B. Now I am doing experiments and have readings for A, which I want to type into a spreasheet and have Excel look up the corresponding value of B. Is this possible? If so, how please? -- Wendy

How to add asterisk to source data

Postby RmVhdGhlciA1Mg » Sat, 23 Sep 2006 00:12:02 GMT

We want to add an asterisk to several numbers in our data source, but when we 
add the asterisk to the source data, it disappears from the chart.  How can 
we keep it from doing that without putting the asterisk in a textbox and then 
moving it around all the time whenever there are changes in the chart?

Re: How to add asterisk to source data

Postby Jon Peltier » Sat, 23 Sep 2006 03:04:24 GMT

If you put an asterix into a cell, you convert the cell from a number to a 
text value, and it is interpreted as zero. Are the numbers data labels on 
points? You could highlight the particular values in a number of ways. You 
could put them into a different series with differently colored markers. You 
could put them into a different series with differently formatted text. etc.

- Jon
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions

Re: How to add asterisk to source data

Postby Del Cotter » Sat, 23 Sep 2006 03:17:41 GMT

On Thu, 21 Sep 2006, in microsoft.public.excel.charting,
Feather 52 < XXXX@XXXXX.COM > said:

Create a custom number format like one of these:


Whatever suits you. It should be just the format you're using already 
with "*" added on the end. Apply the format you created whenever you 
want to add an asterisk to a number, and the result will be a number 
that displays properly on your chart, but displays with an asterisk on 
your table.

Del Cotter
NB Personal replies to this post will send email to  XXXX@XXXXX.COM ,
    which goes to a spam folder-- please send your email to del3 instead.

Re: How to add asterisk to source data

Postby RmVhdGhlciA1Mg » Sat, 23 Sep 2006 03:21:02 GMT

The numbers are data labels on points and the asterisk would highlight 
certain numbers and then have a footnote related to the asterisk.  Thank you 
anyway though.  I appreciate your help.  feather52

Similar Threads:

1.Pivot Table data source "data source contains no visible tables"

I'm trying to create a pivot table from an external Excel spreadsheet.   Yet 
I am getting the following error "data source contains no visible tables". 
Any idea what that means?  Thank you in advance.

2.Add asterisk to excel cell

How do you add an asterisk to the begining of a excel cell? or replace
the zeros with a asterisk? For example, data come in the cell as 01222
but I want it like this:*12222




3.add source data to chart in excel

I can't get Excel to accept more than 19 data points for my X-axis in a 
chart? Is this a limit? How do I add more data points? (As soon as I try to 
add the 20th point, all of the other points are lost.)

4.Auto Data Source Adding

I am developing a series of charts that will have data added to them on a 
monthly basis.  Specifically, I would like the data source to add one column 
of data every month.  Currently, all I could come up with was highlighting a 
bunch of empty fields and letting the data catch-up.  The problem with that 
is: it leaves a big blank space in the chart.

Any ideas?

5.Adding multiple source data to chart

I have a column chart with two x-axis'.  I have a data 
line representing stock prices running across the chart, 
and stock volume in columns.  When I add a second stock 
price line, the first one disappears.

6. Adding more source data to existing scatter plot

7. Adding Source Data to a Chart.

8. Add source data to an existing chart?

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 41 guest