Floating Toolbar As Default In Pivot Chart

Jun 28, 2007

I've created a Pivot Chart in which I want to display travel by various folks to mulitple sites. The Site field is a Page field. If I set the Pivot Chart to a Custom -- Floating Bar style it displays fine, but if I change the Page field selection the chart reverts back to a stacked bar style.

I've tried setting the default chart type to Floating Bar (this doesn't take), and naming a custom style that is Floating Bar (and setting the pivot chart to this custom style -- but again the style does not hold on a change to the Page field).

I ran into this a few years ago and wrote some event macros to reformat the chart when the sheet is activated and when it calculates, but it seems there should be a simpler (built-in) way. Am I missing something obvious? Is there a way to make the Floating Bar style stick in a pivot chart without resorting to VBA updating?

View 9 Replies


ADVERTISEMENT

Create Floating Toolbar (not Menu)

Jan 13, 2007

Need to code to create a custom floating menu which appears on opening the workbook. It works brilliantly, but I'd like to adapt it so that I can create a floating toolbar, which is fully expanded upon opening, where the button faces are plain text which I designate. Let's suppose the macros I want the buttons to trigger are called MacroA and MacroB, and that the text on the buttons should read "Do A" and "Do B".

Sub Create_Menu()
Dim MyBar As CommandBar
Dim MyPopup As CommandBarPopup
Dim MyButton As CommandBarButton
Delete_Menu 'make sure commandbar isn't already running
Set MyBar = CommandBars.Add( Name:="My Menu", _
Position:=msoBarFloating, temporary:=True)
With MyBar
.Top = 175
.Left = 850
Set MyPopup = .Controls.Add(Type:=msoControlPopup)
With MyPopup
.Caption = "My Tools" 'change to suit....................

View 6 Replies View Related

Custom Floating Toolbar Created - Icon And Size Questions Remain

Oct 16, 2008

I have created a custom floating toolbar that works perfect (thanks to all the reading on here!). My workbook is a stand alone estimating tool that many users will have a copy of.

I have two things I want to do yet but I cant find it on here.

1) My buttons on my toolbar - I want to have custom icons. I can do this temporarily but when I exit my worksheet and re-open they are lost. Is there anyway to save a custom icon. I am willing to add it to the icon list if necessary and then when users open the workbook copy the custom icons onto their computer. But I am not sure how/where I could do this.

Worse case, can I color my button text?

2) When my toolbar appears, it is wide, all buttons are going left to right. I want the size to be small width so the toolbar buttons are on top of each other. Any thoughts? I tried adding a .width but it didnt work.

View 9 Replies View Related

Floating Bar Chart With Y Axis

Apr 16, 2008

I have a dataset that looks like this ....

View 9 Replies View Related

Pie Chart Floating Values

Jun 20, 2007

I have created a chart in a chart sheet (using VBA) - all well and good. Now I notice that if I place the mouse pointer over any of the pie slices, I see text similar to the following

Series 1 point "Swedbank" Value: nnnnnn (n%)

Now obviously (?), the name Swedbank is from the source data and the nnnnn (n%) are the values to be plotted. I'm wondering 2 things Can I "format" that text in any way, for example, so it shows Swedbank, value: nnnnn (n%)If I can, can I also format the numbers so that'll end up something like 1 234 567

View 2 Replies View Related

Floating Bar Chart In Step Formation

Jul 24, 2007

I am trying to create a floating bridge bar chart.

Here is my data and I will try to describe as accurately as I can.

FY 2004 operating margin = 14.6% (while FY 2005 and FY 2006 = 11.2% => So the difference is 340bps)

The "bridge" back to 14.6% = 90 basis points for Jimmy'Z, 30 basis points for stock option expense, 30 bps for marketing -- that's 150 bps of the 340 and I'm trying to quantify the rest of the bridge but is there a way to show this in excel with floating bars - that is to say the 14.6% bar will touch the axis but the other 3 data points are not touching the X axis but are in the air in a step formation... ?

View 4 Replies View Related

Pivot Table With Dynamic, Updatable Chart, But Not A Pivot Chart!

Dec 19, 2008

My boss wants me to design a dynamic, updatable chart in Excel 2003. I initially made a Pivot Chart based on a Pivot Table which worked perfectly, but it doesn't look professional enough when printed (or viewed) and she wants me to approach it a different way.

So, I created a graph based on the data in a Pivot Table, and used dynamic ranges as the source for the graph series so that the chart updates when the criteria fields are changed for the Pivot Table. I then added two combo boxes (ie data validation lists) to the Chart sheet, and wrote VBA code so that whenever the combo box values are changed, the Criteria fields for the Pivot Table on the 2nd sheet are updated accordingly, and this in turn causes the graph to be updated as well.

This solution also worked perfectly, but now I've been told to create the graph without macros.

Does anyone have any suggestions? The requirements/details are as follows:

1. The Pivot Table is on sheet "PIVOT", and the graph is on sheet "GRAPH"
2. The Pivot Table has two criteria - School Name and Year Level
3. On sheet "GRAPH" there are two data-validated fields, School and Year, which only allow the selection of valid Schools and Year Levels

Is there any way to make the Pivot Table update when values are changed in the fields on the CHART sheet so that the chart also updates, but without using code nor a Pivot Chart?

View 9 Replies View Related

Pivot Chart Object: Find Any Suitable Object To Choose From To Make A Pivot Chart In Powerpoint

Mar 21, 2007

1) i have office 2003 on a laptop. within powerpoint, i can create a 'microsoft excel chart 11' object. to create a link to the excel data source, do i have to go through the odbc sql setup? it works, but i don't want my powerpoint to be dependent on some excel file somewhere. what are the other options to insert/make a functional pivot chart in powerpoint with the data also within powerpoint? the data as sheet option does not result in the chart being a pivot, it's just a plain chart. it has to be a proper object, not an image paste or a chart that updates links with the excel file open.

2) i have office 2007 on my other laptop. i can not find any suitable object to choose from to make a pivot chart in powerpoint. what's the best way to go about in 2007 version?

3) am i going about this the wrong way with the objects? should i be after vba code?

View 4 Replies View Related

Hiding Pivot Table Toolbar

May 17, 2006

Whenever I click on a pivot table, the pivot table toolbar pops up. Generally, I like this, but it confuses my users of this workbook. Is there a way to hide the toolbar just for this workbook?

View 3 Replies View Related

Excel 2010 :: Can't Find The Pivot Table Icon In The Toolbar

Mar 31, 2012

I can't find the Pivot Table icon in the toolbar. I tried "Insert", I can only see the 'table' icon, but cannot see the 'pivot table' icon. how can I find this 'pivot table' icon, or create it in the tool bar?

View 4 Replies View Related

Excel 2007 :: Default Chart Size?

Jan 6, 2014

I have excel 2007 and I came across the following difficulty:

If I create a graph (or a chart) the default size is "Letter". However, I can switch this "Letter" to "A4" which I need and then create a template. But I always have to manually choose this template for new charts. However switching this any time I create a new chart is a rather bad way to cope with. Even clicking on set as default obviously does not cause to have A4 size for new chart, it still has got size of Letter when adding a new chart.

I assume the solution could be in XLStart templates, but it probably doesnt work for charts that you add. Or at least I didnt find any clue on the internet for this problem.

View 3 Replies View Related

Change Default Chart Type & Color

Sep 7, 2007

I was just wondering if there was a way of changing the excel chart default so it doesn't always return a grey (or gray for those of you over the pond !) plot area every time I create a chart. It looks rank and wastes toner IMO.

View 8 Replies View Related

VBA To Set All Pivot Fields To Default Values

Mar 14, 2008

I am finishing up a macro that manipulates a pivot table and creates a file for us to run. But we all keep this pivot table up a lot, and usually keep a lot of the data filtererd in it.

Is there a way to set all of fields in a pivot table back to their default values like when you first open up the workbook?

View 9 Replies View Related

Pivot Table - Page Default

Jun 16, 2006

I have defined 2 pivot table report using the same master data. I wanted to default the page field in these reports. I notice that on refreshing the data, the pivot table page field updates with "All" instead of default one (if there is no data for the default page field). How do I fix this? I wanted to have the default page even though there is no data for that field in the master file.

View 5 Replies View Related

Default Pivot Table To No Subtotals

Jun 6, 2007

Pivot tables. They have a habit of adding automatic subtotals to each field of data you drop into the pivot. Is there any way of setting the default to "none" rather than "automatic". It's driving me insane.

I am toying with the idea of writing some code to eradicate this issue, but if there's something native to Excel which will do the trick, that would be much more efficient.

View 7 Replies View Related

Show Missing Values In Pivot Chart (line Chart) Axis?

Apr 18, 2013

How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.

View 1 Replies View Related

Pivot Table Summary Measure Default?

May 8, 2007

The summary measure for my data field buttons my pivot table wizard is defaulted to count instead of sum.

How do I change the default back to sum.

View 7 Replies View Related

Pivot Chart Error: Unable To Set The _Default Property Of The Pivot Item Class

Aug 15, 2006

I have created quite a nice little macro that;
drills through a lot of key figures, updates a pivot chart and copies the chart to powerpoint.

However it crashes on one particular data set every time with this error:
Run-time error '1004':
Unable to set the _Default property of the pivot item class

The code where the debugger stops is the last line below here.

lngKpi = Sheets("Helpfile"). Cells(lngRow, 2)
Sheets("Charts").Select
ActiveSheet.ChartObjects("DK").Activate
ActiveChart.PivotLayout.PivotTable.PivotFields("KPI # (overall").CurrentPage = lngKpi

I can manually change the pivot chart to the keyfigure it crashes on and thereby workaround the problem in the macro. Also it works for more than 50 other keyfigures without problems.

View 9 Replies View Related

Pivot Table Field List Default From Count To Sum

Dec 21, 2011

How can I change my Pivot Table Field List to produce Sum of the values rather than Count of Values?

View 1 Replies View Related

Default To Classic Pivot Table Layout In 2007

May 9, 2008

I have upgraded to Excel 2007 and the PivotTable formats are different. I prefer the old 'drag and drop' formatting, and would like to default to that.

I can switch to the classic format by going to Pivot Table Tools ---> Options ---> Display --> Classic Pivot Table Layout, but I have to do this for each table I create. I'd like this to be the defaut choice.

I've searched the board and someone posted that if you add the Pivot Table/Chart icon to your task bar, that will open the old layout --- it opens the wizard, but the table that is created is still in the new format which does not enable drag and drop.

View 9 Replies View Related

Using Scroll Bar To Modify Axis Of Chart - Maximum And Minimum Values By Default?

Sep 22, 2013

how to link axis properties with a scroll bar (two scroll bars).

The idea is to be able to modify the maximum and minimum values for the axis in case there are outliers which might cause problems by analyzing the chart.

The Guideline in the scroll bar should be set to its maximum (all the way up) by Default, meaning that if there chart behaves itself well there is no need to change its axis values.

The same applies for the minimum guideline of the scrollbar but it should be sent all the way down by Default.

View 1 Replies View Related

Excel 2010 :: Change Default Pie Chart Colors In Recorded Macro?

Mar 20, 2014

I am working on a project where I am virtually almost finished except for a minor change with the pie chart. I am analyzing some data and recorded a macro to do this and also the pie chart for visualization. However, I do not like the color of the default pie chart colors and would like to customize it. How could I change this within the macro I have recorded?

[Code] .....

View 4 Replies View Related

Forms Toolbar Versus Control Toolbox Toolbar

Oct 19, 2006

which of these toolbars provides the better 'controls' to paste onto worksheets (as opposed to UserForms)? For those wondering, both toolbars contain some apparently similar controls, e.g., combo box, radio button, spinner etc. but there are differences in their behaviour it would seem...

View 2 Replies View Related

Excel 2010 :: Changing Default Chart / Graph Format Copied When Pasted Into Word?

Aug 28, 2012

I work with a team of users that are continually publishing reports in Word that contain charts and graphs copy and pasted from Excel into Word 2010.

We have a custom script that leverages a PDF engine to automatically convert .doc files to .PDF files that we distribute electronically to our clients. This all works great, but only if all my users select 'paste special' and Enhanced Metafile Format when adding their excel charts into our reports. Most of these people aren't tech savvy, and I'm havin ga hell of a time getting them to follow this workflow and am hoping there's a way in Office 2010 to select the default paste from excel into word when the content is a chart.

It seems like the default paste from excel is an embedded chart/graph that you can then further manipulate each component of the chart in Word; the default doesnt' paste an actual image. I am assuming the pdf renderer is using a lower resolution .PNG version of the image and when these are scaled for print and or pdf, they look like crap.

Is htere anyway I can automatically change the default paste format for the chart from excel into word to be an EMF/EMV (enhanced metafile?) Either thorugh the registry or some other saveable setting?

View 1 Replies View Related

Convert Chart Into Pivot Chart

May 16, 2006

Please look at the sample workbook below. The chart you see below is fine BUT I would like in a pivot table chart, so I could select any days on the pivot chart. I have tried it to do it myself but for some reason the time is not displaying on the pivot chart correctly. Any help please ?

P.S. If not possible then can we add a scroll bar or something?

View 6 Replies View Related

Pivot Chart Changes Chart Upon Refresh

Aug 12, 2006

I have created a pivot table and chart. The pivot chart consists of three sets of data from the pivot table. Two of the data sets are lines and the third data set is displayed as columns. I made the third data set into columns by right clicking on the data series line and selecting chart type. I change the chart type for that data set to a column and it worked great. The only problem is that when data is refreshed in the associated pivot table, the entire chart turns into columns with completely different formatting. Does anyone know how I can maintain the graph with the two lines and one column data set when I refresh the data?

View 4 Replies View Related

How To Create A Pivot Chart

Apr 7, 2014

I am trying to create a pivot chart that show the average response times in hour but for some reason my charts looks not right. The axis show a max of 1 but the graph itself showed us up to 17. I think easier to explain if I attached the worksheet.

View 2 Replies View Related

Add Top Five Rank Without Using Pivot Chart?

Oct 13, 2011

Within a pretty large key indicator report I would like to add a top five rank without using a pivot chart.

View 3 Replies View Related

Chart Without Pivot Table

Jan 3, 2013

If I want to produce a pivot chart using VBA can I do it without producing the pivot table?

I am guessing that the following are a possibility:

Do in a virtual sheet that is not shownhide the sheet (can do already)

I am looking for the virtual sheet option or something similar.

View 2 Replies View Related

'Top 10 Autoshow' In Pivot Chart

Feb 1, 2010

Hi everyone - I'm just starting to get my head around the wonderful world of pivot tables and pivot charts, and I'm stuck ...

I've managed to build a pivot chart exactly how I need it to look ... except that there are 140 different data fields showing, and I only want the top 10 values to be displayed. The top 10 would then update depending on the Page Fields selected.

My searching for an answer keeps returning results that say "click Field Settings, then Advanced, then Top 10 Autoshow" etc but the Advanced option doesn't show in the associated Pivot Table - I only have 'OK', 'Cancel', 'Hide', 'Number' & 'Options'.

So is it possible to use Top 10 Autoshow in this case? And how would I go about it?

This is what the pivot chart looks like at the moment: ....

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved