Controlling Gap Width for BAR Chart
I have the following data for example.
A = 2
C = 4
I can create a 2 D Bar chart from this quite easily.
Now If I make the data to
A = 2 , 3
B= 3 , 4
C = 4 , 5
I do want to plot the data on the basis of first two values as
mentioned in the first example, but I want to control the width of the
Bar from the value given after comma. Please help.
On Sat, 24 Feb 2007, in microsoft.public.excel.charting,
Fazi <email@example.com> said:
>I have the following data for example.
>A = 2 , 3
>B= 3 , 4
>C = 4 , 5
>I want to plot the data on the basis of firs...Multiple charts in one big chart -- how to rotate to vertical position?
I have 3 small charts set into one larger landscape chart. I can
manipulate the small charts, but if the page were oriented vertically
instead of horizontally I could expand the small charts to reveal more
Anyone have a clue what I'm talking about, or how to achieve this
|| | | ||
|| | | ...Charting
I am trying to figure out a way to add an additional Y-Axis line to a chart.
Current chart is a standard bar chart with about 10 rows of data (cost
breakdown). I want to add a cost per square foot, but when I try to add it
to the Y-Axis by creating a custom bar line chart, it wants to add other
lines of data to that axis. In addition, I can't get rid of the cost per
square foot in the data table. It is not a per project total like the bars
in the graph, but a cumulative cost per foot for all bars in the graph.
In addition, I want to show the totals of all the data per project wit...Question about charts
If I have two lines in a line graph and they criss-cross
(like a supply and demand curve), how can I find the exact
values on the x and y axis where the two lines cross? Is
this possible by using Excel?
Let's hope you made XY chats (no Line charts) - change chart if necessary
Insert Trendlines for both (better yet use SLOPE and INTERCEPT functions)
So Now you know y1=m1x1+b1 and y2=m2x2+b2
At point of intersection y1=y2 and x1=x2
m2x+b2 = m1x+b1
y = m1x + b
Its all rather simple algebra.
Bernard (you can call me Prof <grin>)
&quo...How to label bubbles in bubble chart
I'm trying to graph multiple rows, each of which has 3
data values. I want to graph a bubble chart whose X-axis,
Y-axis, and bubble size represent these 3 data values.
But I also want the bubbles to be different colors so I
can distinguish them by row. Finally, I'd like to label
the colors with row names in the legend. Is this possible?
> I'm trying to graph multiple rows, each of which has 3
> data values. I want to graph a bubble chart whose X-axis,
> Y-axis, and bubble size represent these 3 data values.
> But I also want the bubbles to be dif...Dynamic chart #9
is it possiable to make a chart like this, I got the dates in the first row,
that is B01:NC01 the data is in B25:NC01, this row has a forumla in it, which
gets updated each day, what I want is a dynamic chart that, will only show
the current month, so when the first comes around the chart will again be
blank, I know that the number of days in the month will change with each
Is there any way to create a chart like this, I know how to use, the name
...how do you add names on a bubble chart?
hi does anyone know how to add names on a bubble chart?
In article <D3AD4FAC-A0D3-4C77-AF73-72313357E6CF@microsoft.com>,
> hi does anyone know how to add names on a bubble chart?
What do you mean by "names?" Series names? Chart or axis title? Data
labels? Custom text? Something else?
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
I bet he wants custom data labels. Here are two great (and free!)
utilities for labeling Excel charts:
Rob Bo...names, labels
I have 12 worksheets, one for each month of the year. Each worksheet does
identical calculations, so I need the names to be worksheet defined rather
than workbook defined. And indeed they seem to be, yet they still cross
sheet boundaries. For example on the June sheet, Insert>Name>Define shows:
Loan =June!$D$8:$D$15 but the July, August, etc. sheets all see the June
definition of Loan. In other words, if on the August sheet I use
=sum(Loan), it calculates the result for the June sheet. I would have
thought that June! would have hidden these names from any other sheet. How
do I keep...Excel 2007 Chart in VB6 Program
I have another thread in the VB group and was told to post to these two
groups so sorryfor the multi-post. Ill post there again just in case folks
want to follow the thread.
So I've had a Visual Basic 6 app (as an EXE) that has worked great for the
last 9 years or so. Up until Excel 2003 I have had to make minimial changes
it to work properly. The app has an OLE control which acts as a container
different external sources .In this control I embed an Excel workbook and
display a chart sheet. I can interact with the workbook through the normal
Excel programming objects...Provide the ability to add a horizontal line to a chart in Excel
At times an event happends for which a horizontal line is a good visual
indicative of the expected change in a timeline chart.
Try this sites for some examples of adding lines to charts
> At times an event happends for which a horizontal line is a good visual
> indicative of the expected change in a timeline chart.
Andy Pope, Microsoft MVP - Excel
...Chart in Excel
Is it possible to convert a Chart in Excel so that it is "fixed", ie. still
looks the same, but is no longer connected to the source data ? I know that
I could save it as a jpg, and then insert it as a picture, but is there a
way to do it more directly.
I have a note in my notes
after drawings chart in conventional way
1.click the chart
2.highlight the formula in the fomrula bar
now the chart is based on actual data and not cells.
try a few small experiments.
"OM" <OM@youknowwhere.com> wrote in message
news:44f57d15$0$11970...change bubble order in a bubble chart
I have inherited a company bubble chart that compares the outcome of a
calculation with 3 variables with an ideal. Sometimes project value - the one
that sets the size - is smaller than ideal. In this case the bubble for the
project is eclipsed by the ideal. How do I modify "bubble order" to decide
which is in-front and which is behind?
This is accomplished by sorting the data high to low, or by sorting the
series in the chart, larger values to smaller.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
&...X-Axis Units Disappear in Stacked Area Chart (Excel 2007)
I have a stacked area chart that charts percentages over 12 months
(Jan-Dec). This chart also includes a data series of 100% (as a line
chart). Both series, one plotted as a stacked area, the other plotted
as a line chart type are on the primary axis.
The x-axis is set to display Jan-Dec. The y-axis is set to display the
In the axis option I have set the unit choices to auto. When I save
and close the file that contains the chart and then re-open, the x-
axis only shows Jan on the x-axis. When I go back into the Axis
Options dialog box, the major unit, minor unit, and base unit op...Bubble Sizes in Bubble Chart
Hi, I'm having issues with sizing the bubbles in my bubble chart. I want them
to be uniform, but when I enter the size number for the first one, it changes
the size for all other bubbles within the chart. So either there is one HUGE
bubble and several small ones on the chart, or there are several huge bubbles
and one small one. I've tried starting from scratch, using other numbers for
the size; nothing is working.
You want the bubbles to be uniform? As in, all the same size? Then use the
same value in the bubble size column for all of the points. They will all be
the same size...Charts sums 2 data series
Have 2 col of data and names 2 data series. But the second series is a total
of the first no. plus the second no. I want each col to be a separate line
on the chart.
Right click on the chart, choose Chart Type (or Change Chart Type
depending on Excel version), pick the first subtype, which is just
arbitrary series, not the second, which is stacked, or the third, which
is stacked to 100%.
Peltier Technical Services, Inc.
> Have 2 col of data and names 2 data series. But the second series is a total
> of the fi...location of chart
The option to have the chart on the same sheet is not available. Why not?
will need more information to even have a guess.
> The option to have the chart on the same sheet is not available. Why not?
Is the sheet/workbook structure protected?
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <9A832669-4C00-40CE-A265-E4A9772CF20B@microsoft.com>,
> The option to have the chart on the same sheet is not available. Why no...Bubble Charts
When I try to chart data using bubble charts, the resulting chart doesn't appear to represent the data at all. Am I missing something?
It's hard to say... the bubble chart will want
X and Y values, along with a bubble-size value
(the 3rd value). Do you have that kind of data?
If not, check the data sources (right click on chart)
to make sure the values you want are being used
in the manner you're thinking.
>When I try to chart data using bubble charts, the
resulting chart doesn't appear to represent the data at
all. Am I miss...excel data label format special number characters
I'm trying to create bar graphs containing fractional data labels. The catch
is, I want each bar in the series to have a different denominator value.
Excel allows you to preset the denominator (e.g. - ?/4), but that denominator
affects all members of that series. The question is, is this do-able and if
so what special character(s) allow(s) my task to be performed?
...How do I name the Bubbles on my Bubble chart.
I created a Bubble Chart using the help feature but I need to name the three
Bubbles. I don't know how to lay it out in excel and then copy the range to
The easiest way to give the bubbles different names and have the names
appear in data labels is to create three different bubble series. The data I
used in a little demo is like this:
1 1 1
2 2 2
3 3 3
Each mini range contains the series name in the middle cell of the top row,
with X, Y, and bubble size values in the bottom row.
Select...limiting chart source data with criteria?
I know for a series you choose:
is there anyway to limit it further by saying something to the effect
Values: =A2:10 but not equal to 0, like Values =A2:A10 <> 0 (I know
that doesnt work, already tried it, but its kinda what I want to
I can go in and manually ctrl click through to limit the data source,
but thats a pain, I'd rather choose 1 big block and have some statement
exclude 0 values.
I could sort the data....but according to my boss thats not an option,
because she wants the order to be the same quarter to quarter no matter
what the values....Charting dynamic range
Ok let me say i fully understand how to name a range and in the source data
use the formula =sheetname!rangename
Problem arrises when my macro that runs an advanced filter with the source
data and add data to the bottom of the range the chart reverts back to it's
initial data source =sheet1!$a$4:$b$15
so even though it accept the named range intitailly once the advanced filter
runs it almost ommits the named range. I am using 2007 and i never had this
problem in 2003.
What suggestions do you have for me?
Can we creat Shadow/Duplicate Chart in 2nd Workbook.
for example in Workbook1 i have charts, I want these chart to appear in
Workkbook2 as well, when i change data source or apply someformatting on
charts in Workbook 1, Charts in Worksheet 2 reflect the changes automatically.
You can copy the chart and paste it in the other workbook or sheet and if
the data changes for one the other chart will also change. However, the is
no built-in way to get the second chart to change formats as the first chart
But you could use the Camera tool to copy a picture of th...X Axis Tick Labels
I have created X axis tick labels number format at axis minimum and maximum:
maks1 = ActiveChart.Axes(xlCategory).MaximumScale
minim1 = ActiveChart.Axes(xlCategory).MinimumScale
znakx1 = "[=" & minim1 & "]""S"";[=" & maks1 & "]""N"";General"
.MinimumScaleIsAuto = True
.MaximumScaleIsAuto = True
.TickLabels.NumberFormat = znakx1
In some cases this works fine. But in some I have maximum label as...Bubble Charts in Excel
I am trying to map the position of plants using X and Y coordinates and the
area cover by each plant using the diameter in a bubble chart of Excel, but
the graphs look unrealistic. I would like to know what is the equation Excel
uses to calculate the size (area) of each point in the bubble charts so that
I can adjust my size parameter.
Thank you so much,
As I understand it, the bubble sizes are relative sizes. If you want the
data to be smaller, you'll have to put in a data point with a "large" bubble
size that you can make invisible. This will rescale the bubble ...Charts: Can the Default settings be changed
The defalt background is grey and the line colors are awful. How do I
change these default settings so that I can avoid having to change
each line width, color, point size and shadow. We're can I find the
menu to make this change
On Tue, 24 Jul 2007, in microsoft.public.excel.charting,
jimbo <firstname.lastname@example.org> said:
>The defalt background is grey and the line colors are awful. How do I
>change these default settings so that I can avoid having to change
>each line width, color, point size and shadow. We're can I find the
>menu to make this change
Press F1 and ...