Using images in bar charts
I know there must be an easy way to do this... I need to
use an image of a thermometer, where the red bar in the
thermometer replaces the typical bar in the bar chart.
I've searched on Google, and found a couple of things, but
they're technically beyond my capability! I know you can
use a graphic in Excel, but doesn't the graphic end up
being distorted? I will continue experimenting and
searching for the right answer, but I thought I'd tap into
this community and see if I get an easy answer.
Try Pope's wonderful site. Search down the list and you will see his
t...Determine if data label overlaps chart title?
Hello again, all you experts. I now have run into a new issue
when generating charts via VBA.
I add data labels only if the datapoint belongs to a particular
company. Sometimes, the data label
is on the last (and highest) point on a distribution curve. It
then runs into the title of the chart.
I've been trying to capture this in code but am at a loss. I
can't find any property of the data label
that tells me its top. I haven't even gotten to trying to
compare this with the bottom of the chart title!
What I want to do is change the data label's position to bottom
i...Labels on a chart
I have a Column Chart where I am charting values in column E. E2 contains
the results of =C2/D2, E3 contains the results of = C3/D3, etc. These values
are displayed above each of the columns in the chart.
What I need to do is also display the value contained in C2 below the column
repersenting the result of =c2/D2, I need the value in C3 below the column
representing the result of =C3/D3, and so on.
How can I get this accomplished?
Thank you very much for any insight.
If you can live with the values of columns C and D being positioned just
within the plotarea above the x a...how to make the axis of charts to start at my lowest value(data)?
actually, i am making a chart with values starting at 40 to 85.
when i plot the chart, it is located somewhere in the middle upto the end
because excel tries to plot 0 to 40 on my x axis which i do not want.
what i want is that the x-axis of my chart should start at 40 then probably
by interval of five upto 85. also my y-axis to start at 140 upto ~180.
here is my data.
pls help. thanks.
Rightclick on the X-axis --> "Format Axis" -...Acces to Excel automation : chart problem
This is my first post so apologies if i don't observe any etiquette.
I'm coding Access to Excel to create an xls file with a sheet of
figures and a chart embedded on the sheet.
I've got most everything going fine BUT I can't get the X Category
Axis set up on the graph.
Any suggestions will be most appreciated.
Here's the code:
'Create the first Chart - month to month figures
Dim chart1 As ChartObject
Set chart1 = xlSheet.ChartObjects.Add(10, 200, 920, 300)
...Copy charts from 1 workbook to another
I have created a macro which copies some charts from one workbook to
another. It has to repeat this for several tabs of the workbook. I
need to know if i need to create an object to copy n paste these
charts or can it be done without an object. A quick reply is
I believe you would just need to create a worksheet variable combined with a
worksheet loop to copy all of the charts.
If I'm understanding your question correctly, something like this should
Dim wks As Worksheet
Dim cht As ChartObject
For Each wks In Worksheets
...Weekend dates show on chart, not on spreadsheet
I am collecting data for workdays, so the weekend dates do not show on the spreadsheet. When I create the chart, the weekend dates show. How do I eliminate them from the chart
Right click on the chart, choose Chart Type from the pop up menu, and
make sure it's a Line chart not a Scatter chart. Then right click again,
this time choose Chart Options, and on the Axes tab, change Automatic to
Now you'll only have an axis tick where you have a date in your data table.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and...Conditional Formatting in charts?
I want to make the highest value in a chart display BOLD type. I know
how to do this in a group of cells using conditional formatting --
=MAX($C$14:$C$23), then set font to bold.
But conditional formatting doesn't work on a pivot table once it's
refreshed. My chart was created from a pivot table. Is there any way to
do this without creating a new chart from scratch?
...organisation charts in excel spreadsheets
Is it possible to put spreadsheet cell references into a staff organisation
chart so that if, say, the salary or grade in the chart is changed it updates
a separate spreadsheet showing total staff costs.
No. I've encountered the same problem. Not even in MS Visio is there a
solution for this. It's a re-typing job.
> Is it possible to put spreadsheet cell references into a staff organisation
> chart so that if, say, the salary or grade in the chart is changed it updates
> a separate spreadsheet showing total staff costs.
>...Line chart Axis labels problem
Trying to produce a chart with wizard from two columns of
...Date and Time Chart
I have data that consists of a due time, a submitted time, and 3 types of job
categories. Essentially, what I would like to have is the date along the x
axis, the jobs on the primary axis, a secondary axis with times, a bar chart
with the types of jobs and the due times and submitted times to be trend
lines in the same graph.
Is this possible? If so, what is the best way possible to achieve this?
You should be able to find something here that helps.
"KC8DCN" <KC8DCN@discussions.microsoft.com> wrote i...Excel Chart in Word
I have a Word 2000 document with some embedded Excel (2000) charts. The
charts themselves are quite small, and so use a very small font (Gill Sans
Light @ 5pt). When I print the document, one of the charts looks great, but
the others seem to use the wrong font (it looks like Arial).
Even if I copy the "good" chart, the copy suffers from the same problem as
the others. This is not specific to one machine (a colleague has replicated
the problem), nor to one printer (I can get the same result when printing to
My colleague did manage to get all the charts to come out correctly af...Chart features unavailable
I installed Excel 2007. In some workbooks that I used in 2003, the charting
features are no longer available. I can't create new charts, nor access old
ones. The old ones can be viewed but the formatting can not be changed. In
new workbooks, the features are available.
..."Disable Send/Receive" button
Office Outlook 2007, SP1
On one of my computers, I was able to customize a button for "Disable
Scheduled Send/Receive," but now I can't remember how I found it. I'm trying
to customize the same for my notebook.
Online searches say that I can find that command under
Tool>Send/Receive>Send/Receive Settings, but the only choices I find there
are "Define Send/Receive Groups" and "Show Progress."
Where's the "Disable Scheduled Send/Receive" command?
SILENT COUNSEL, a legal thriller
Tools-&g...Capture chart elements in VB
Is there anyway, if I have an existing chart that is formatted already, to
capture the all elements of that chart in VB (by recording a macro perhaps)?
Have a spreadsheet that contains hundreds of charts, all of which are the
same format, but due to non-adjacent data sources and multiple chart types
within one chart, it's very tempermental - need to standardize.
Also, is there a list contained within a spreadsheet of all components of
that spreadsheet? Primarily trying to capture the chart names to utilize in
VB coding without having to start recording a macro and then selecting ea...Charting a calculated number using the source data as the axis
I would like to chart the result of a series of calculations. I am
calculating net debt to ebitda and the result will be 2.0, 2.5. etc. I wish
to plot the result but show the original numbers used for the axis. In other
words I want net debt to be one axis and ebitda the other with a line
representing the result of net debt / ebitda (2.0, 3.0, etc.).
Thanks for assistance.
Select your data range including your "net debt" and "ebitda" columns, then
Insert Chart, and use the XY chart type.
"Ebreese" <Ebreese@discussions.microsoft.com&...charts: 1. link to a cell in chart titles, 2. custom chart template
how can i make a link to a cell in chart title, category axis & value axis?
i'd like to know how to make a title like eg below:
[=B2], [=B3]' <- in line below (smaller font size than in line above)
how can i make a my own chart (custom type) by making a own template (how to make a template, and how to implement it to excel
custom types charts)
i am interested in making types similar denkin diagram (similar to radar type) or leontief branch flow matrix (similar to x-y plot
with columns and rows with second x axis and second y axis)
is there a...How to insert a symbol in a chart legend?
I tried to insert Alpha in a chart legend using Excel, but I did not find a
way. Does anybody know how to do it? I am using Excel 2002.
If you select a letter in the cell used for the legend and format it with
Symbol, the legend does not change because formatting does not get carried
over. Nor can you format a single character in the legend.
BUT is you go to the cell that is used for the legend and use Insert|Symbol
to get Greek letters then the legend reflects the change. I'm using XL2003;
I know that XL2002 has Insert | Symbol but with older versions you may need
t...How do I set up a Pareto chart in Excel?
It would be useful if I could display some information in a Pareto chart.
Excell dosn't seem ot offer this option.
Can anyone point me in the right direction?
This site described the process:
> It would be useful if I could display some information in a Pareto chart.
> Excell dosn't seem ot offer this option.
> Can anyone point me in the right direction?
...updating chart using edit query
I import a column of date into column A which is linked to a chart. When I
update the column of data the chart updates automatically. Great! Except
not all columns of data I import have the same number of items. So I am
forever adjusting the range the chart refers to by clicking the line on the
chart and then pulling the handle on the blue box that surrounds the cells
from the previous data range (eg. A1:A25, and getting the blue box to just
surround the new data range (eg. A1:A20).
Can I get the chart to recognise that I want it to reflect only cells with
data in them (e.g. A1...Leader Lines
Help! Is there any way to use automatic leader lines to the data labels with
stacked column charts???
Pie charts are the only ones with built-in leader lines.
Stack column charts only have the option of positioning the labels Top,
Middle or bottom of column.
Are you manually moving the data labels?
I guess, as long as the chart is not 3d, you could fake the leader lines
using dummy xy scatter series.
Andy Pope, Microsoft MVP - Excel
"suejay" <firstname.lastname@example.org> wrote in message
I have a sheet with 2 charts which get their data from some calculated cells
that I'd really like to hide, but when I hide them, the chart dissappears.
Even making the columns 0 width does this.
Is there a solution to this?
if the chart is in seaparate chartsheet then try hiding the sheet in which
the data is locatesd instead of row
Neil G <email@example.com> wrote in message
> I have a sheet with 2 charts which get their data from some calculated
> that I'd really like to hide, but when I hide them, the char...How to change chart legend text (Excel 2007)
How cna I change the text in a charty legend. They all say "Series1".
Don't your series take their legend from a header row?
"Prof Wonmug" <firstname.lastname@example.org> wrote in message
> How cna I change the text in a charty legend. They all say "Series1".
On Sat, 19 Dec 2009 11:06:46 -0000, "Bob Phillips"
>"Prof Wonmug" <email@example.com> wrote in message
>news:kv3pi5dlerubjclhcgmgsueg16q6pn...Emphasize one Line on Horizontal Axis of Bar chart
I created a column chart of sums that each of 11 travelers have in their
accounts. The total due is $1800. I have major units in the Axis set at 200.
I would really like to emphasize the 1800 line - not set maximum there, just
emphasize. Max is set at 2000 or possibly 2200. I have seen charts in
magazines where this was done - I do not know if I should use a different
chart type or if there is some way to tweak the column chart. In playing
around I can get that line with different chart types, but then the data
flows downward from that line. Should I just try to simply draw a line ...How do I rank chart data so it appears in a specific order?
I want to organize the charted results in decending order of longest bar to
shortest bar so a natural progression or trend can be seen easily. Help!!
Usually a chart depends on data in a worksheet.
So, sort the data.
"kim" <firstname.lastname@example.org> wrote in message
>I want to organize the charted results in decending order of longest bar to
> shortest bar so a natural progression or trend can be seen easily. Help!!
An alternative to Mike's suggestion is to...