I am trying to add the date my charts were created. I have the date the charts were created in a cell then I added a text box to each chart referencing the cell with the date. On some of the charts the date is showing. But on other charts on same sheet, the date only shows when selecting the chart area of the chart but disappears when selecting other charts or cells on the same sheet.
View 6 RepliesHow 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 I have created a pie chart showing top 10 best selling categories. However, on this pie chart, I want %age of overall sales to be shown.
At the moment say I put in the following
Catalogue 1 100
Catalogue 2 98
Catalogue 3 92
Catalogue 4 85
Catalogue 5 84
Catalogue 6 75
[Code]....
I add Data Labels and select the percentages. This shows at Cat 1 having 12.5% of the sales (100 of 800 sales), Cat 2 having 12.25%, and so on..... However, what you don't see is the following data:
Catalogue 11 60
Catalogue 12 58
Catalogue 13 57
Catalogue 14 57
Catalogue 15 56
So based on 1,088 sales, Cat 1 at 100 is actually only 9.19% of TOTAL sales.
I understand what is happening, the chart is giving the percentage based on the data inputted into the chart.
I did consider adding an 11th category to the chart, which was the total of Catalogues 11-15. Whilst this does give a more accurate percentage figure (as now all sales have been inputted), it makes the chart look ****
Is there a way of either adding the 11th category, and then "hiding" it, so that the chart doesn't display it, but uses it's value to calculate Catalogues 1-10s percentage?
BTW: The reason I ask is that I could be dealing with anywhere from 30 to over 100 catalogues. So it's not ideal showing the others in 1 chart.
I'm trying to display a graph I've created in a worksheet, in a userform. But it won't work ..
Private Sub UserForm_Initialize()
Sheets("graphraw1").Select
image1 = ActiveChart.ChartArea.Select
End Sub
Is it possible to show a table on a chart?
ie. Display a Range of Cells right on the chart?
I'm creating an Excel chart, and I have some data that goes from 0-100. I want to show all of the data, but I'd like to have a different format when it goes above 90.
View 4 Replies View RelatedI have a spreadsheet where users can enter a time using the 24 hour clock - these times are random and can be anything within the 24 hour period.
I want to create a chart or graph that has a timeline of 24 hours, (in multiples of 1 hour starting at 07:00 and going right through to 06:00), and I need the times entered by the users to appear on the chart to give an overview of when these incidents are happening most.
I was thinking that the cluster or scatter chart might work but I can't figure it out. I don't actually need both X and Y Axis, just a timeline - is it possible?
Any way using a macro so that a chart will not show the "0" columns?
View 6 Replies View RelatedI have a pivot table/chart that I need to show the sums as top 20 (or any other number) and All others. How can I do this.
I have an example file here: [URL] ...........
I have a chart with event timestamps (2008-06-09 14:48:15.973) and two event types (A and B) with about 12000 events in total. I want to show a chart (probably line chart) that plots the frequency of events on a time axis (e.g. very many event A last night, not so many today, etc). I figure two time series with A and B independently so user can compare visually. But I dont know how to efficiently convert the events into a counter/frequency of events variable/column.
Ive looked into DSUM, DCOUNT & FREQUENCY functions to make a new column that shows how many events have happened in the previous 10 minutes without success. DCOUNT/DSUM problem: some of the criteria fields are computed by formula (date column minus ten minutes).
I have a chart that feeds from dynamic ranges which contain whole rows of null enteries displayed as #N/A. The charts do not plot these enteries (as it shouldn't) however it does display the category label even if it too is #N/A. Is it possible to remove the category label if all data for that row is null. ie the label is also removed from the chart.
View 2 Replies View RelatedI have a chart with multiple series which I am hoping to show/hide based upon a particular value attached to each series. I was therefore wondering if it was possible to extend the Series object class so that I could have something along the lines of a "Series.specialvalue" property which I could assign and then check to decide whether to show or hide the series?
View 1 Replies View RelatedI have 10 graphs with more than 20 legend entries. However, each graph only needs 3-4 elements out of the 20 legend entries in the graph. Is there any way to force Excel to only show those legend entries that have a value? (without deleting them manually)
View 12 Replies View RelatedAttached is an excel file of my issue. I want to stretch the graph so it shows at least 3-4 months. at the moment is only shows 1 month.
Timeline format - Copy.xlsx‎
Split from How To Set Up A Spreadsheet The Right Way
Taking onboard what you suggested I have "rethought" the layout and it is now in a single table format. What had stopped me doing this previously was the fact that I was not able to show 7 days a week for 48 weeks in columns. However thanks to the transpose function all the data is now more user friendly (See Attached Workbook)
You mention the data should be quite easy to manipulate from here, any ideas as I am struggling with the concept of how to display the data in a time series. I assume that it will involve some form of lookup function referenced to the table of times, but thats as far as i can get.
Attached is a simple chart and I would like Users to be able to tick a checkbox to show/don't show 'available' series. In the example If the User clicks for Group 1, then only Customer A's data is shown. If Only Checked Group B, then Customer B and C are displayed. If both boxes are checked, then all three Customer's figures will show. (Hopefully depending on what's ticked, the chart's scale would adjust accordingly)
View 3 Replies View RelatedI created 5 charts and instead of having them spread everywhere in the worksheet, I would like them to be "reduced" to some kind of a link contained in a cell (at the botom of the data of each chart). Then, I would like the chart to appear only if I put the mouse on this cell.
View 4 Replies View RelatedI have created a line chart that plots weight of a person, but want to show on the plot area what a certain range of weight represent, Ive attached images to show this concept.
View 4 Replies View RelatedI have got a lot of data to put in a chart that updates every 5 minutes with new data - i have a chart that Line chart that shows this.
It shows the cost of something every 5 minutes.
I have put this in a chart using offset but obviously i want to show the cost over the course of the day - because this updates every 5 minutes, the axis at the bottom (which has the time of the data) is massive and doesn't look good.
Is there a way to show the axis at an hourly interval but keep all the data in the chart?
I have a spreadsheet where I track income (positive) and expense (negative) items and compare budget to actual amounts. I want to create a simple bar graph comparing budgeted amounts to actual amounts for each item.
However, when I do this, I see all of my income items above the line (pointing up) and all of the expense items below the line (pointing downward).
Is there an option I can select to just use absolute values for the items so they all appear above the line?
I am trying to create a chart that would show all of the Amount values for each Size value that is in the example data below. The Size column has fixed values. In my example the values are: .5, 1, 2, 5, 8, 13 and 21. The Amount column data is variable. Any of the static Size values can be associated with many Amount values. I was attempting to have the static Size values on the X (horizontal) axis and the Amount values on the Y (vertical) axis. I would like to have all of the Amount values for each Size value be shown directly above the corresponding size value, in one vertical line. See example below.
I an creating this type of chart in Excel 2010.
Note, I am still new to this forum and don't know how to post pictures or Excel data into my posts. I am also using dots (periods) to provide separation in my examples.
Amount...Size
58.5.......21
1........... 0.5
2........... 1
1.5.........1
27.5.......13
12.5.......5
2............1
3.5.........2
17.5.......8
4........... 2
48..........21
0.5.........0.5
15..........5
11..........2
Chart that I am trying to create. The chart example is not to scale.
...........60.|
...............|..........................................................................*(21,58.5)
Amount.50.|
...............|..........................................................................*(21,48)
...........40.|
[Code] ........
I have a spread sheet were the area is getting very limited. I need to insert a small icon and when the mouse goes over (like it does in a form tool tip) will show the value of a cell (text value) located in another sheet in same workbook, or I was thinking inset a comment next to the icon and link the comments of the comments text to cell with the text value.
View 14 Replies View RelatedI have a spread sheet were the area is getting very limited. I need to insert a small icon and when the mouse goes over (like it does in a form tool tip) will show the value of a cell (text value) located in another sheet in same workbook, or I was thinking inset a comment next to the icon and link the comments of the comments text to cell with the text value.
I've look the properties of this to objects and can figure it out.
I want to create 3 command buttons (active X) on a worksheet to toggle between showing rows which only contain the below text in column L (range L9:L30) and showing all rows containg the options (However, I also have some blank rows in this range and i always want them to remain hidden.)
My text options are:
High ‚
Medium ՠҪ
Low ’á
The text arrives in the cells via a VLOOKUP
Is the chinese text a problem? i can't type it into VB.
I've been using the following macro to hide and unhide rows with a command button in the same sheet:
Private Sub CommandButton1_Click()
Toggle_Hide_Unhide
End Sub
Sub Toggle_Hide_Unhide()
Dim rngCell As Range
Dim TakeAction As Boolean
If ActiveSheet.CommandButton1.Caption = "Hide" Then
TakeAction = True
ActiveSheet.CommandButton1.Caption = "UnHide"
Else
TakeAction = False
ActiveSheet.CommandButton1.Caption = "Hide"
End If
For Each rngCell In ActiveSheet.Range("I9:I30")
With rngCell
If .Value = 2 Then .EntireRow.Hidden = TakeAction
End With
Next rngCell
End Sub
I am trying to write a function that will compare the text of cell "A2" to the text of cell "B2" and display cell "A2"'s text characters that didnt match from cell "B2" in column C. Can anyone help me out with writing this formula?
EX: ....
I just recently installed Excel 2007 and I would like to know if it's possible to change all data points of a chart at the same time. In Excel 2003, I would normally hold down shift while clicking on each of the data points to make a global change. However, it appears I cannot do that in 2007.
I would like to display each data point's series name. When I go to Layout on the Excel Ribbon, and click on "Data Labels", and click on "More Data Label Options", the actual Y-axis values are shown for each data point. However, I do not want this - I actually only want the Series Name, but when I uncheck "Value" and check "Series Name" instead (under "Label Contains"), it only changes it for one of the series. Is there a better way, instead of going through each and every single series to make this change?
I want to get only the amount in a cell that contains date, name, and amount sample:
in A1:A2
1970 Mario Gonzalez $700
1973 Mario Krupa $500
i want only the amount of Gonzalez to be display in b1 (or any cell beside that "Gonzalez" name), and if not Gonzalez then no text to be display.
I have a excel file that tracks completion rates and has lots of formulas but there is one that I cannot figure out.
I want a formula that will display "not completed in time" (for example) if completion isn't 100% by the planned completion date. The problem I have is that I want to have a record of this and if the completion rate becomes 100% after the planned completion date it will no longer show "not completed in time". Is there a way to setup a formula that will show data in a cell if the formula has EVER met certain criteria.
I have over 2000 cells like the following
S304
S205
S204
S306
S207
and so on
Is there anything I can do to show just the numbers and not the S at the start without me having to delete each S individually?
it is possible to make this in excel?
i make a scroll down and when i select a word show below some text pre defined by me