Excel Dynamic Chart #5: Dynamic Chart Labels using TEXT function and Ampersand &

I have a dynamic Chart with the X axis values from B18 on down and the Y axis values as C18 on down.
I am using an XY Scatter plot.
The Y axis labels are showing up as the plotted values from C18 and down (which is exactly what I want), HOWEVER, the X axis labels are not the plotted values, rather they are just the number in the overall series, i.e. 1, 2, 3, 4 etc...

I need the X-axis Labels equal to the X-axis plotted values

Excel 2007. Am I missing something simple?

Thanks everyone!

I have designed a reporting system with dynamic pie charts to represent the data, which works fine. When new data is added, I have to click into each pie chart to re-tick the category and name boxes to ensure the new charts are labelled correctly.

1) Is there a way to ensure that all charts in a workbook are automatically refreshed and labelled correctly when new data is added?

2) I have been using the commonly sited macro to 'clean up active chart' to ensure that zero values are suppressed. Can this be extended to include all charts in a workbook?

Thanks

Howdy All!

I've been working on a project in Access. It works fine, and exports tables to Excel. The number of records varies each time the Access file exports. Therefore, I've created a chart w/ dynamic ranges.

The chart works fine....It grows and shrinks accordingly. I'd like to include a line to show the average...dynamically. I found an equation that works w/ dynamic ranges. This function works well (found in cell C2).

However, I can't get that info turned into a line on my column chart. When I add that value into the chart, and change it to a line chart, I end up w/ one single data point. Understandably, because that's all there is.

Therein lies the question: How do I apply that value dynamically for each record so it shows as a line on my chart?

I've tried using trend lines, but they don't actually average...so they're not very helpful.

Attached is an example. Feel free to play w/ the data (add or remove as you will). The column chart changes accordingly, as does the average value in C2. But...I'd still like to get the average value to show as a line...

Thanks for the help.

Hi,

I have a simple line graph created from 2 columns of data: Date (x) and Count (Y).

I want to place data labels that will call out an event for a particular day.

So for 08-01-10: It could have one or more different data labels of an event for the corresponding (Y)-data.

The data would look something like this:

Date Calories Event 1 Even 2 Event 3 Event 4 08/01/10 1520 Eat Sleep Exercise TV 08/02/10 4743 Eat Sleep TV 08/03/10 3730 Exercise 08/04/10 3669 Eat Sleep 08/05/10 3493 Eat Exercise 08/06/10 2805 Eat Sleep TV

So for 08-01-10 The corresponding data point would have a label that read: "Eat,Sleep,Exercise,TV".

But I also want to be able to just display the data points of a Chosen Event.

Does anyone know of a third party program that can do this? Or built-in Excel functionality?

Thanks,
Mike

I am money manager in Chicagoland area... I'm charting quarterly historical performance for the past 11 years. I'm using dynamic charting so that I can adjust the date range within those 44 quarters to display the results I want to see. The charting is working the way I want. However, when I select to display the end-point data labels the labels only display on the date range I have selected. When I change the range, they either disapear or appear in the middle of the date range (at the end date of the previous date range). However, if I go back to the range the labels display correctly.

How do I make the end-point data labels display no matter the date range I have selected when both the first and last dates can change?

I am very much an excel amateur, so try to speak english!

I have designed a couple of graphs using named ranges to give dynamics to the number of series in a chart. This works fine as long as I don't want to copy and/or move the sheet to a new work book. When I do this, Excel chooses to remove all references to the named ranges in the SERIES forumla and replace them with fixed references (despite having scoped all named ranges to WS scope).

From googling I found the tip to save the WB as a template and use Insert sheet to add the graphs. This does not quite work as expected though. The SERIES formula points to the right named ranges, but when I update data the graph is not updated. If I save the new workbook and reopen it, it works as expected. Other quirks include not being able to Insert a second template without saving and reopening (the named ranges points to wrong sheet if I do not do this).

So my question is two-fold; has anyone seen this problem before and solved it? Or, has anyone been able to successfully copy/move a sheet and keep the named ranges without involving a "relink" macro?

Hi all. I'd like to add dynamic text in a chart. The user should enter the text in a cell and this text should appear in an SPECIFIC part of the chart. How to do that??
Thx a lot.

How can I insert in a chart (not as data, but as text) a cell value, whether
a number or a word? The idea is that as the cell changes in the spreadsheet,
the number or word changes in the chart area. Any help is greatly
appreciated.

Is it possible to create a dynamic chart which will accommodate the addition of an unknown number of additional dynamic series using Excel 2007?
That is, I have a db query feeding a table and there will be new rows added each day AND new columns:

............Employee 1.....Employee 2.....Employee 3.....Employee 4.....Employee 5
Jan 1.....10....................5
Jan 2.....9......................1
Jan 3.....12....................11..................8.....................55
Jan 4.....14....................12..................10...................1...................1
Jan 5.....19....................13..................13...................11.................10
Jan 6.....12....................15..................16...................16.................18


As you can see, there is more than one series and new series come on line all the time as new employees are added.

I can easily define the dynamic range:
rowscell=counta(a2:a9999)
columnscell=counta(b1:b9999)
myrange=offset(mysheet!$a$1,0,0,rowscell,columnscell)

However, when I try to use myrange as the graph data range I get a "The formula you typed contains an error" dialog.

Any suggestions?

Is there a way to link text in a chart title to a cell so that the contents of the cell are displayed as the chart title?